Display REF CURSOR output of Procedure in table format
605724Mar 11 2009 — edited Mar 11 2009
I'm using SQL Developer 1.5.3. The REF CURSOR result is not displayed when executing the following code. I understand that fetch and loop through DBMS_OUTPUT.PUT_LINE is required to display the result - but this is not displayed table format. However, some 3rd party tools, seem to provide this functionality - where without fetch and looping through DBMS_OUTPUT.PUT_LINE, the result is displayed in table format.
Is there any work around to display REF CURSOR result in a table format in SQL Developer?
bq. create or replace PROCEDURE GetEmpRS \\ ( \\ p_deptno IN emp.deptno%TYPE, \\ p_recordset OUT Types.cursor_type) \\ AS \\ BEGIN \\ OPEN p_recordset FOR SELECT ename, empno, deptno FROM emp WHERE deptno = p_deptno ORDER BY ename; \\ END GetEmpRS;
Thanks in advance.