problem in my current Operating System Windows 7 that I installed Oracle DB and Developer suite Ver "10.1.2.0.2" and I tried to install Jinitiator latest one that version jinit13130 and with no success to be installed even I copied the jvm.dll from latest Java to initiator directory and still didn't work. I even tried to disable Add-ons and still didn't work.
I heard that I have to use Java instead than Jinitiator I did as is mentioned in this page [URL] and also in this documentation pdf but still with no avail. In the website is mentioned that I have to put in the forms formsweb.cfg to add these thing
"instead of the archive_jini tag, use the archive tag archive=frmall.jar,...,my_jar.jar"
I found that my_jar.jar is not in any folder so I escaped this file from the line and only mentioned frmall.jar. and I did the rest but still didn't work, by the way I received this message when I run a form "FRM-10142: the http listener is not running on Candy-PC at port 8890. start the listener or check your runtime preferences".
I newly installed the Forms 10.1.2.0.2 and my database version is 10.1.0.2.0.
I hope it successful installed. I done the following workings
1. Edit preferences done perfectly. 2. OC4J also started.
When i run my 1st sample form. On my 1st run it should ask for Jinititor installation. But my run is not asking the Jinitiator installation and form is not running.
Even tried with run a form on web option it is also not running
I am trying to invoke program from my local Windows machine (exactly java executor, which is in my environment on c:javajdkinjava) using database package with Java stored procedure.
Everything is fired by SQLPLUS script, this script invokes package with Java stored procedure (jar loaded into Oracle) and that procedure is trying to invoke runtime process (syntax:
c:javajdkinjava -cp
and here ara my classes and main jar) using my local java executor. I added all permissions using dbms_java.grant_permisions (execution forced me to give permissions java.io.FilePermission to <<ALL_FILES>> for execute), moreover I added to my database user JAVASYSPRIV and JAVAUSERPRIV role. Unfortunately, beside this I am still getting error:
C:javajdkinjava not found (Note that lookup with PATH isn't done due to the oracle executable being setuid.)
Everytime when i want to start up my 10g the Applet freez and nothing happend, the Browser hangs and i only able to kill the Browser.i open my Controllpanel of the Java and go under:
general -> Temporary Internet Data (Button)--> Settings
then a new window pop up. Then i Press delete data, after that Press ok and it works the first time. When i try to start again without delete it does not work again.
I use 10.1.2.0 Forms and JRE 1.6.0_20. I read about that there is a new check in this Version (jar files signed and unsigned) but the files are Signed.
I am writing a java stored procedure in my package. In the java procedure I want to issue a query to be fired on the user table from which I am calling the java procedure.
Some thing like following:
I am logged in to USER1 and my package is inside USER1. From this package I am calling the Java Stored Procedure. In java procedure I want to make a jdbc connection to USER2. The details of USER2(password, hostname,portno) are stored in a table called 'connection_details' and this table is in the USER1.
My problem is how can I issue the
SELECT details FROM CONNECTION_DETAILS for USER2
so that i can get the details..?
Do i need to first make jdbc connection to USER1 and then execute the above query for which i need similar details of USER1. How can i obtain the details of USER1 here.
I am thinking if I am already in USER1 then do I need to make the jdbc connection to USER1 and then execute the query?
I've this java source create or replace and compile java source named "Decodificador" as public class Decodificador { public static String decodifica(String codigo) return codigo;
and this function
create or replace function F_Decodificador(codigo varchar2) RETURN VARCHAR2 IS LANGUAGE java NAME 'Decodificador.decodifica(String) return String';
when I execute the function the result is:
ORA-29531: no method decodifica in class Decodificador
I need to call DB function through Java Hibernate.
My Sample XML File looks like. --------------------------------------------------------------- <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <sql-query name="getchequeno" callable="true"> ?:=call cz_nab_mw_fn_gen_ol_chq_no() </sql-query> </hibernate-mapping> --------------------------------------------------------------- I am getting below error while reading the file
"java.lang.RuntimeException: org.hibernate.HibernateException: Errors in named queries: getchequeno"
i`m trying to use pl/sql function to execute java class. I created 2 tables with around 100 values and java class with simple functionality. I need to create function to loop through my table1 and get with each iteration one value from table and pass that value as parameter to java class.
table1 is something like this:
ID NAME 1 name1 2 name2 3 name3 . . . . 100 name100
table2 is empty with same columns as table1 ( table2 is for data obtained from java returns ) I created in sql+ java class.
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "myClass" AS import java.io.*; import java.util.* public class myClass { public static String fun(String strName)
[code]....
Then i wanna make a pl/sql function for:
1)For i = 1 Obtain first value from table1 (column name) and pass it throught java class then return value and save it in table2 with the same id as id from table1
I am using oracle developer 10g R2. Now i would like to create a java(jar) function or any other type then would like to add this jar file into my oracle form with a button and when i run this and click on this button then display the message from java function.
when I import java class from oracle forms (import java class ->> FFileChooser) appeared FFileChooser package but i don't know how use it how use OPEN_DIALOG or other function .
I need to add one validation in one form. The form is not getting run locally because of some imported java classes which was already there. From application server it works fine. When i run locally it gives ORA_JAVA.EXCEPTION_THROWN. Actually some trigger calls a procedure from this imported java class. Some path is specified in JNI.NEW_OBJECT(). That patg may not be in local system. If those files are included in our oracle home directory
I am having Oracle 9.2.0.1.0 client in my PC and jdk version is 1.6
I had configured below tools in my PC. (windows 2000) I am having Oracle 9.2 with Oracle Developer Suite 10g (10.1.2.0.2) which contains Oracle JDeveloper 10g (10.1.2.1) also.
How to call a java function from Oracle forms? code samples and how to integrate those thing?
In my PLSQL package ...How do I invoke this class file ?
So far I have done this ...
Declare abc ORA_JAVA.JOBJECT; xyz ORA_JAVA.JOBJECT; xxx VARCHAR2(25); value ORA_JAVA.JOBJECT; BEGIN
[code]...
I am getting an error saying the object type is wrong .... I would like to know how to assign a hardcoded value to the JOBJECT just to test before I continue.
Our system stores images on the unix filesystem. We scan full page images.
Our image specs are:
black and white: tiff, group4 compression, 300dpi. so files are about 40-80k compressed
photograpshs/gray scale: jpeg/jpeg compression 256 gray scale. Some images can be 2megs...but most of them are about 400-700k
We build a demo with forms10G/application server 1 year ago and performance was really bad. Took about 10-15 seconds to generate a report with 1 image of it...compared to about 1-2 secs using forms 6i. We just installed weblogic 11G (10.3.5) with forms 11gr2. I'm guessing performance will still be an issue but we will still be testing it.
Our users currently use nfs to access images on the unix server. So that would not changed.
- read_image from filesystem (c: unc path //server/images/.../1.jpeg)
- zoom in, zoom out (having vertical/hori scroll bars to move around...or best would be panning)
- save_image on filesystem
- fit to window/cancas
- always keeping aspect ratio
nice to have options, but not needed at this time
- save in blobs
- editing capabilities (mostly just select an area to delete, like black borders...some speckles here and there)
I want to create chatting Application using/without using pjc java bean. I want to develop application internal chatting application without using IP address. if there is any possibility by using only System name users can chat. Because we are using dynamic IP address configuration.
I am trying to use the Java Importer tool to invoke web services from Oracle forms.
During my research on Java Importer tool, I found that Quote:"The class browser lists all of the Java classes found on the CLASSPATH. The classes are ordered in the same way that they are represented in the CLASSPATH."
The above quote is from Oracle Documentation.
I want to know where I can find the CLASSPATH so that I can add new Java Classes to it. Our forms builder runs on Unix environment.
On a Windows 2003 64 bits server I have installed Oracle Application Server 10gR2 10.1.2.0.2 (Infrastructure + Business Intelligence and Forms option). I also upgraded to Portal 10.1.4. All components are up and running.
I wanted to test if Forms services are functional using the test form provided by OAS at installation (test.fmb/.fmx).
Steps executed:
1) Start -> Programs ->Oracle Application Server 10g -> Forms Services -> Run a form on the web for form=test.fmx
or in the IE browser:
2) [URL]
The applet is not starting and I receive the following error:
I have a rather hard to trace problem which is keeping me up several days now. We want to implement a package for querying devices via SNMP in our database. There are no packages shipped with Oracle that come handy. UTL_TCP does not work because SNMP works via UDP. After all we came up with the idea to use URL.... Locally on my development machine and on the command line of the Oracle database our first prototype of the SNMP query function works very well, but inserted into the database all I'm getting is a "Request timed out". Firewall mechanisms can not be the problem because the java code runs smoothly on the command line and also a snmpwalk on the command line suceeds, so the database is not blocked by any firewall. First I thought some permission via Java are missing, but I took a look in the USER_JAVA_POLICY view and worked this with SYSDBA out. A java application in Oracle connection via TCP to port 80 and fetching a website works allright, the thing not working seems to be UDP.
