Creating a Procedure

To create a procedure:

1. On the Workspace home page, click SQL Workshop and then Object Browser.

   Object Browser appears.

2. Click Create.

3. From the list of object types, select Procedures.

4. Enter a procedure name and click Next.

5. Define the arguments by specifying the following information (optional):

   • Argument Name

   • In/Out (the parameter mode)

   • Argument Type (datatype)

   • Default (value)

   To add additional arguments, click Add Argument.

6. Click Next.

7. Enter PL/SQL block you want to use as the procedure body and click Next.

   To view the previously defined arguments, click Defined Arguments.

   A confirmation page appears. To view the SQL used to create the procedure, click Show SQL.

8. Click Finish.