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

Home -> Community -> Usenet -> c.d.o.server -> Switching on SERVEROUTPUT in a stored procedure

Switching on SERVEROUTPUT in a stored procedure

From: ali beidoun <a.beidoun_at_donau.de>
Date: Mon, 13 Apr 1998 13:00:43 +0200
Message-ID: <3531F05B.E7A0E09C@donau.de>


Hi,

     Does anybody know, how to switch on the serveroutput and set the buffer size in a stored procedure?

My procedure generates many warnings and nonfatal errors, and i would like -some way- to display the output within a SQL*Plus session. Now I'm using the package dbms_output. But when the user, who executes this procedure (within a Plus session only!), doesn't know or forgets this fact, the procedure must do this for him.
I don't want to use a script where i can do this, since i should make a

copy of the script for each user.

Thanks in advance for your replay

ali Received on Mon Apr 13 1998 - 06:00:43 CDT

Original text of this message

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