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:
- 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.
- View the results that correspond to the run action in the
SQL Results view. You can view messages, parameters, and
result sets.