How to pass values and see outout of PL/SQL Tables, SYS_REFCURSORs?
I am new to SQL Developer (Version 3.0.02).
Our QC division wants to test stored procedures using SQL Developer.
I tried to test procedures with PL/SQL tables and SYS_REFCURSORS as input and output parameters.
When we run it by pressing the green arrow we get the Run PL/SQL window.
How can we:
- Put values to SYS_REFCURSOR and PL/SQL table type input parameters?
- How can we display SYS_REFCURSOR and PL/SQL table type output parameters?
All this time we were using SQL*Navigator. In Navigator the PL Tables and SYS_REFCURSORs outputs are shown in a nice grid.
Here, in SQL Developer, do we have to WRITE our own code to input and display these types of parameters????