Oracle Fusion Middleware Blog

Deutsche Informationen rund um Oracle Fusion Middleware

Calling Web Service from Forms

leave a comment »

OK, for an OO-experienced person this seems to be obvious but sometimes it helps to clarify things. If you call a web service client (web service stub) from Oracle Forms you have to import one or more classes of the web service client into the Forms module.

There are different case:

    1. If the class is static the signature of the imported methods in most cases only contains simple datatypes like in this example
      FUNCTION <method>(
      a0 VARCHAR2,
      a1 VARCHAR2,
      a2 VARCHAR2) RETURN BOOLEAN;
      This can be handled easily from your Forms application by passing the appropriate values.


    1. If the class is non-static, i.e. there are existing instances of this class you will find an object in the signature of the PL/SQL method call: FUNCTION <method>(
      obj ORA_JAVA.JOBJECT,
      a0 VARCHAR2,
      a1 VARCHAR2) RETURN ORA_JAVA.JOBJECT;
      In this case you have to pass an initialized object for this class by using the method new in your PL/SQL code:
      obj := <class>.new();


  1. If the class is non-static and requires an additional object to be passed as a parameter to the called method the signature of the PL/SQL method call could look like this:
    FUNCTION <method>(
    obj ORA_JAVA.JOBJECT,
    a0 ORA_JAVA.JOBJECT,
    a1 VARCHAR2,
    a2 VARCHAR2) RETURN ORA_JAVA.JOBJECT;
    In this case you have to pass an initialized object for this class by using the method new in your PL/SQL code:
    obj := <class>.new(); and
    to initialize an additional object for the parameter by importing the required class into the Forms module and create a new instance:
    a0:<additional_class>.new();

<JM>

Written by fmtechteam

13/01/2008 um 23:03

Veröffentlicht in BI Publisher, Forms, Jürgen Menge

Tagged with

Schreibe einen Kommentar

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s

%d Bloggern gefällt das: