Before i start writing about my problem i want to say that i was searching any solution about my problem and didnt find....
First of all i created WebServiceProxy from tutorial Calling a Web Service from Oracle Forms (JDeveloper 10.1.3.1 and Oracle Forms 10.1.2)
Everythink is allright in this. I can call WebService from JDeveloper in my main() function.
Later i did method to call it from Oracle forms.
Deploy java do .jar file
Added .jar file to CLASSPATH in my local computer.
Import to oracle forms designer.
Wrtie pl/sql function to call java code like in tutorial.
Compile -> Save -> Copy form to server -> Compile form.
Add .jar file to location $ORACLE_HOME/forms/java
Add CLASSPATH to this .jar file to $ORACLE_HOME/forms/server/default.env file.
Add .jar file to
stop and start application.
Now try to test all . Going to my form and trying...
Geting FRM-40735 trigger raised an unhandled exception ORA-105100
when i add below code to my exception in my function
WHEN ORA_JAVA.EXCEPTION_THROWN then
ex := ORA_JAVA.LAST_EXCEPTION;
err_msg := Exception_.toString(ex);
message('some error' || err_msg);
but ! when i rem Exception_.toString(ex); i have
FRM-40735 trigger raised an unhandled exception ORA-105101
i want to say i have imported Exception_ class, String class, StackTraceElement class to my form designer.
The last think i did, was remming
// ServiceFactory factory = ServiceFactory.newInstance();
// _port = ((webserviceproxy.proxy.LoyaltyCardSOAP11BindingQSService)factory.loadService(webserviceproxy.proxy.LoyaltyCardSOAP11BindingQSService.class)).getLoyaltyCardSOAP11BindingQSPort();
code in constructor in my java code to get only an object from
|JO := LoyaltyCardSOAP11BindingQSPort.new;|
but still the same problem....
i read all web sites i think to find solution... didnt find...
Can anybody help me ?
The problem to communiate java classes and forms solved !
i have add my .jar file to $OA_JAVA/oracle/apps/fnd/jar and now i can communicate between forms and java.
I can create an object, i can get simple message from class, but when i try to create
ServiceFactory factory = ServiceFactory.newInstance();
ive got ORA-105100...
can anybody help ?