Previous
Previous
 
Next
Next

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.