You can use the New Stored Procedure wizard to create stored
procedures.
Before you begin
Ensure the following requirements are met:
About this task
Routine development using a wizard is not supported for
every available data source. See Routine support by server type for
details.
Procedure
To create a stored procedure from a data development
project:
- In the Data Project Explorer, right-click the Stored
Procedures folder in a data development project, and click
. The New Stored Procedure wizard opens.
- Complete the steps of the wizard.
If you
opened the wizard by using the toolbar button, you must provide project
and connection information in the wizard.
After you specify
a name and language, select a template to use as the starting point
for your stored procedure. Some templates are included with the product,
or you can create your own templates to share with other team members
using the Preferences page.
For Java™ stored procedures, you must specify a Java
Package and a Jar Name.
For
the Java stored procedure, the value of Java Package is
the package name of the Java class. The Jar Name is
the name of JAR file of the Java stored procedure that is installed
on target server. The values of Java Package and Jar
Name are part of the Java stored procedure external name
in the DDL to create the Java stored procedure.
Results
The wizard creates the stored procedure and adds it to the
Stored
Procedures folder, and the stored procedure opens in the
routine editor.