Running PL/SQL routines and packages

After you create and deploy a PL/SQL routine, such as a stored procedure or user-defined function, you can run the routine on the database server. For routines that are inside PL/SQL package, run the PL/SQL package

Procedure

To run a PL/SQL routine:

  1. In either the Data Source Explorer or the Data Project Explorer, right-click the PL/SQL package or routine that you want to run, and click Run.

    Tip: You should not run routines by using the Run As option from the pop-up menu in the routine editor.

    The routine runs on the database server. If the routine has parameters, a window opens where you can specify parameter values.
  2. View the results that correspond to the run action in the SQL Results view. You can view messages, parameters, and result sets.

Feedback