how to print ref cursor result in toad
Hi All,
I have problem with refcursor in TOAD .Here is my procedure returning refcursof as a out parameter but i don't know how to declare & print a refcursor in TOAD ( in sqlplus i can do this).
PROCEDURE wcm_duplicate(pv_tname VARCHAR2,pv_col_name VARCHAR2,pv_cur out sys_refcursor)
IS
BEGIN
OPEN pv_cur FOR 'select '||pv_col_name||' ,count(*) from '||pv_tname||' GROUP BY '||pv_col_name||
' HAVING COUNT(*) > 1 ';
END wcm_duplicate;