Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Serveroutput inside a stored proc
Does anyone know how to 'set serveroutput on' inside a stored procedure?
CREATE OR REPLACE PROCEDURE MY_PROC
IS
CURSOR c1 IS
SELECT column1, column2
FROM my_table
ORDER BY description;
rec c1%ROWTYPE;
BEGIN
OPEN c1;
LOOP
FETCH c1 into rec;
EXIT WHEN c1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE( rec.column1|| rec.column2);
END LOOP;
END;
Also, how can return both columns in a column delimited format without
using ||?
TIA,
Otto
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Mar 22 2000 - 10:22:26 CST