After you create and deploy a Java stored
procedure in a Java project, you can run the stored
procedure on the database server.
Before you begin
The Java stored
procedure that you want to run must be deployed to a database.
About this task
In addition to the Data Source Explorer and Data Project
Explorer, you also can run a Java stored
procedure from a Java project in the Package Explorer.
To
run a Java stored procedure from a Java project:
Procedure
- In the Package Explorer, expand the Java project,
and then double-click the Java stored
procedure that you want to run. The stored procedure
opens in the Routine editor.
- On the Configuration page of the
Routine editor, click Run in the Deployment
and Execution section.
Results
The Java stored procedure runs on the
database server. If the stored procedure has parameters, a window
opens where you can specify parameter values.