Use a REF CURSOR as an OUTPUT Parameter

You can test a PL/SQL function, procedure, or package by defining a REF CURSOR as an OUTPUT parameter in your PL/SQL function, procedure, or package. After you define a REF CURSOR, compile and run your PL/SQL function, procedure, or package. The Run dialog appears. Choose OK.

After you choose OK in the Run PL/SQL dialog, you can view the details of the run in the two tabs:

  1. IdeConnections: Displays the status of your run including any errors encountered.

  2. Output Variables: Shows the output from the execution of the function, procedure, or package.

Related Topics

SQL Developer: TimesTen Tasks

SQL Developer Concepts and Usage