Re: dbms_output.enable problem?

A copy of this was sent to <yliu_at_creighton.edu> (if that email address didn't require changing) On Tue, 7 Dec 1999 16:10:12 -0600, you wrote:

>Hi,
>
>I was trying to use dbms_output.enable(1000000) to change the buffer size,
>my pl/sql program looks like the following:
> dbms_output.enable(1000000);
> DECLARE
> ...
> BEGIN
> ...
> END;
> /
>However, when I run the program, I got the message "unknown command
>beginning "dbms_outpu..." - rest of line ignored". Can someone please tell
>me how to use dbms_output.enable clause?

in sqlplus or svrmgrl, you should use

SQL> set serveroutput on size 1000000
SQL> declare ....

if you really want to use dbms_output.enable -- you need to put it in a plsql block. eg:

SQL> exec dbms_output.enable(1000000)
SQL> declare ....

or

SQL> declare
   > ...
   > begin
   >    dbms_output.enable(1000000);
   >    ....

>Thank you very much for your help.
>Could you please send your response to my e-mail address
>yliu_at_creighton.edu.
>
>
>Yongge
>yliu_at_creighton.edu

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Dec 07 1999 - 19:24:18 CST