Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Serveroutput inside a stored proc

Re: Serveroutput inside a stored proc

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 22 Mar 2000 17:45:02 +0100
Message-ID: <953744738.27843.0.pluto.d4ee154e@news.demon.nl>


1 dbms_output.enable(<size in bytes>)
2 you can't, or you need to do separate dbms_output.put calls and one fine dbms_output.put_line call. Usually not worth the trouble.

Hth,

Sybrand Bakker, Oracle DBA

<osilva_at_my-deja.com> wrote in message news:8barvf$5c9$1_at_nnrp1.deja.com...
> 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:45:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US