2 Replies Latest reply: Dec 3, 2012 3:16 PM by 903396 RSS

    How to Return a value to a 10g Oracle Form form a Web Service Call

    903396
      I've read the demo available from Oracle, 'Calling a Web service from Oracle Forms', that shows how to invoke a call to a Web Service from a Form. The demo only shows how to do a call and how to display messages. I've done some searching, but can't seem to find any examples of how to return a value from the call into a field on the form. If any one could provide an example of that, I would greatly appreciate it.

      We are in the process of modifing a form and we would like to use a webservice, which we have never done before. We have created a webservice which calculates a value based upon what is entered on the form and we want to pass that calculated value back to a field on the form.

      This is the code provided by the demo to do a call.

      DECLARE
      jo ora_java.jobject;
      xo ora_java.jobject;
      rv varchar2(100);
      ex ora_java.jobject;
      BEGIN
      JO := SendServiceSoapClient.new;
      RV := SendServiceSoapClient.sendMessage(JO,:BLOCK3.PHONE_NUMBER, :BLOCK3.MESSAGE_BODY, xo, xo);
      EXCEPTION
      WHEN ORA_JAVA.JAVA_ERROR then
      message('Unable to call out to Java, ' ||ORA_JAVA.LAST_ERROR);
      WHEN ORA_JAVA.EXCEPTION_THROWN then
      ex := ORA_JAVA.LAST_EXCEPTION;
      message(Exception_.toString(ex));
      END;