Install Oracle JDeveloper 9.0.4.

Install Forms Developer 9.0.4.

To create a new workspace and project, select File> New> General> Workspace and click OK.

Name the directory and the workspace WebServiceWS. Be sure that Add a New Empty Project is checked, then click OK.

Accept the default project name and click OK.

With the new project selected in JDeveloper, select File> New> General> Web Services> Web Service Stub/Skeleton and then click OK. The Web Service Stub/Skeleton Wizard displays.

If the Welcome screen appears, click Next to go to Step 1 of 2 in the Wizard. On this screen, in the WSDL Document URL enter the URL that points to the WSDL of the Web service. For this example, the URL is:

http://www.xmethods.net/sd/2001/CurrencyExchangeService.wsdl

Click Next .

Step 2 of 2 in the Wizard displays. This shows the facilities available to be called on this Web service. These should be selected by default. Click Finish .

JDeveloper automatically creates the code required to call the Web service. Save and Rebuild the project.

(Optional Step).When you run a Web service stub from within JDeveloper, the proxy settings come from the IDE ( Tools > Preferences > Web Browser/Proxy ). Because you intend to invoke the Web service stub from Forms, you may have to define the proxy settings in the code. If you are using a proxy, then you must modify the CurrencyExchangeServiceStub constructor.

Replace

m_httpConnection = new OracleSOAPHTTPConnection();

with

Properties prop = new Properties();
prop.setProperty(OracleSOAPHTTPConnection.PROXY_HOST, "myproxy"); prop.setProperty(OracleSOAPHTTPConnection.PROXY_PORT,"80");
m_httpConnection = new OracleSOAPHTTPConnection(prop);

Replace " myproxy" with the host name of your proxy server.

Although you have created only one class, that class relies on a number of other Java classes. The next step is to package all the relevant files into a single JAR file.

Select File > New > General > Deployment Profiles > JAR File - Simple Archive and click OK.

A dialog displays showing the name and location of the deployment descriptor. Accept the defaults and click Save.

The JAR Deployment Profile Settings Dialog displays. Select Dependency Analyzer and check the check box for Oracle SOAP. Click OK.

This creates a deployment node on in the system navigator. Select the node, right mouse click and select Deploy to JAR File .

This saves the JAR file to disk. Note the full directory path and name of this JAR file. You will need this information to set your CLASSPATH in the next step.

Select Start > Settings > Control Panel .

Double-click on System, select the Advanced tab and click the Environment Variables button (or just select the Environment tab on NT).

From the System Variables, select CLASSPATH and then click Edit (there is no Edit button on NT).

Add the full directory name and name of the JAR file created in step 7 above.

Click OK (on NT, click S et , then OK) to dismiss the dialog.

The next step is to update the Forms environment file to indicate the location of the JAR file. The Forms environment file is called default.env in a default installation.

Prepend the full directory path and JAR file name to the CLASSPATH entry.

For example:

CLASSPATH=
d:\jdev904\jdev\mywork\WebServiceWS\Project1\deploy\archive1.jar;D:\...

Start up Oracle Forms Developer and create a new form. Create a canvas and a non-base table block.

Select Program > Import Java Classes and select the Java class created in JDeveloper. Click Import . This creates a PL/SQL package for the CurrencyExchangeServiceStub Java class.

Change the Import Classes field to java.lang.Float (just type this in) and click Options. Check the boxes Include inherited methods/fields and Include get/set for public fields. Click OK.

Click Import . This creates a PL/SQL package for the Float Java class. This is required because the CurrencyExchangeServiceStub returns an object of type Float. This is not native to Forms and so we also need to import the Float object.

Change the Import Classes field to java.lang.Exception (just type this in) and click Options. Check the boxes Include inherited methods/fields and Include get/set for public fields. Click OK.

Click Import . This creates a PL/SQL package for the Exception Java class. While this is not essential, it does make error reporting easier.

Now click Close to dismiss the dialog.

Create a button on the canvas and define a When-Button-Pressed trigger with the following code:

DECLARE
 jo ora_java.jobject;
 rv ora_java.jobject;
 ex ora_java.jobject;
BEGIN
 JO := CurrencyExchangeServiceStub. new;
--
--This will get the exchange rate from US Dollars to UK Sterling.
--
 RV := CurrencyExchangeServiceStub.getRate (JO,' USA',' UK' );
 message (float_.floatValue (RV));
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;

This calls out to the Java class with two parameters. The Java class returns the exchange rate that the code then displays as a message.

Run the form and click the button. The message line now displays the exchange rate from US to UK currency.