Java stored procedures created in Java projects

You can create Java™ stored procedures from methods in Java projects.

You use a single method in a Java class to create a single Java stored procedure. You can use multiple methods in the same Java project to create multiple stored procedures in the project.

During the creation and deployment of a Java stored procedure, dependencies in the Java project are handled in the following manner:

Limitations:

After you create the Java stored procedure, the Java project that contains the stored procedure is visible in both the Java perspective and the SQL and Routine Development perspective. You can operate on the stored procedure in either perspective.


Feedback