Creating Web Services from PL/SQL Packages

You can create a web service from a PL/SQL package under the database connection node in the Connections Navigator. In this case, you have to select the project into which the generated files for the web service are deployed.

To create the web service from a PL/SQL package:

In the Connections Navigator, expand Database , then the database connection, the schema, and Packages .
Right-click the PL/SQL package, and choose P ublish as Web Service to launch the Create PL/SQL Web Services wizard.
For detailed help about completing the wizard, press F1 or click Help from within the wizard.

The files to implement the web service are added to the navigator. For more information about the generated files, see Generated Web Services Files.

Now that you have generated your PL/SQL web service, the final step is to deploy the files to OC4J. This is the same as deploying any other J2EE Web Application. For more information, see Deploying J2EE Web Services to OC4J.