You can create a SQL or Java stored procedure from an existing
SQL statement in the Data Project Explorer.
Before you begin
Prerequisites:
About this task
Routine development is not supported for every available
data source. See Routine support by server type for details.
To
create a SQL or Java stored procedure from an SQL statement:
- Switch to the Data perspective.
- In the Data Source Explorer, right-click an SQL statement
in the SQL Scripts folder under a data development
project, and select Generate Stored Procedure. A wizard opens, with the SQL statement initialized to
the SQL statement that you selected.
- Complete the steps of the wizard.
Results
The wizard creates the stored procedure and adds it to the
Stored
Procedures folder, and the stored procedure opens in the
routine editor.