HOW TO: How can I see the results of a procedure that returns a cursor? (4334487)

Please have a look at the link in the cause section of the solution for further details on this.

Example:

1. Create the procedure below:

CREATE OR REPLACE PROCEDURE cursor_out_param (c_out OUT SYS_REFCURSOR)
AS
BEGIN
   OPEN c_out FOR SELECT * FROM user_objects;
END;

BEGIN
   cursor_out_param(:cur);
END;

2. Go  to the Schema Browser, select the procedure cursor_out_param, r-click and select "Execute Procedure"
3. On the "Output Options" tab, select "Fetch Cursor Data" and click "OK"
4. The window below will appear

5. Click on the Cursor value. The values of the cursor are there: