Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |