DBMS_OUTPUT Cursor
571744Jul 5 2007 — edited Jul 6 2007Hello,
I have question about DBMS_OUTPUT in a SQL Worksheet. Can you just output the cursor instead of having to define a variable for every column. Some of my procedures have quite a few columns in it.
SET SERVEROUTPUT ON SIZE 1000000
DECLARE
v_rs SYS_REFCURSOR;
o_Parm01 VARCHAR2(2000);
o_Parm02 VARCHAR2(2000);
o_Parm03 VARCHAR2(2000);
BEGIN
WEB_REVENUE (v_rs, 'Test_Handle', 'NoParameter', 'NoParameter', 'NoParameter');
LOOP
FETCH v_rs
INTO o_Parm01, o_Parm02, o_Parm03;
EXIT WHEN v_rs%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('Handle' || '|' || 'Last Name' || '|' || 'First Name');
DBMS_OUTPUT.PUT_LINE(o_Parm01 || '|' || o_Parm02 || '|' || o_Parm03);
END LOOP;
END;
Thanks, sck10