About Creating PL/SQL Web Services

JDeveloper's Create PL/SQL Web Service wizard makes it easy to generate and publish a web service from a PL/SQL package or a Java stored procedure that uses object types. A Java stored procedure is defined by a SQL specification that invokes it, and the PL/SQL Web Service wizard treats these in the same way as packages. PL/SQL web services can be deployed to OC4J, or to Oracle Application Server.

The Create PL/SQL Web Service wizard uses the functionality of JPublisher to wrap the PL/SQL in Java so that the service can be published. For more information about JPublisher, see About JPublisher.

You can either:

Create the web service starting from a project in the Applications Navigator. In this case, you select the database connection and the PL/SQL package to generate the web service from.
Create the web service from the 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.

Note: If you edit a PL/SQL web service, make sure that the database connection still exists otherwise you will see an error message. If you have deleted the database connection, create a new one with the same name as the original connection.

To see the files generated by JDeveloper, see Generated Web Services Files.

There are some cases where a web service cannot be created. For more information, see Limitations of Creating PL/SQL Web Services.

Deploying PL/SQL web services is the same as deploying any other J2EE Web Application. For more information, see Deploying J2EE Web Services to OC4J.