Re: 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;
use dbms_output.enable(<Buffer-size>);

Buffer-size < 1.000.000 (in Bytes)

>
> Also, how can return both columns in a column delimited format without
> using ||?

I don't understand your question....

Regards, Stephan

--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------