1 Reply Latest reply: Nov 1, 2013 7:35 AM by Krystian RSS

    CALLING WEB SERVICE / SIMPLE JAVA CODE FROM FORMS 10G FROM SERVER

    Krystian

      Hello everyone.

       

      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

      archive_jini=frmall_jinit.jar,archive1.jar

      archive=frmall.jar,archive1.jar

      in $ORACLE_HOME/forms/server/formsweb.cfg

      later

      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 ?

       

      Regards

      Krystian