Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Switching on SERVEROUTPUT in a stored procedure
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
![]() |
![]() |