Running Java stored procedures from Java projects

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

  1. 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.
  2. 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.

Feedback