Re: Switching on SERVEROUTPUT in a stored procedure

Ali,

To set the buffer size from within the procedure use dbms_output.enable(#######)
where ####### is the size of the buffer you want.

As for setting serveroutput on within the script, if you are handing people a script file, you can have "set serveroutput on" as the first line of the file. If you are telling them to "execute <procedure_name>" from within Plus, then you can set the login.sql or glogin.sql file to include the "set serveroutput on" statement

Rachel

ali beidoun wrote:

> 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:52:09 CDT