Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_OUTPUT not printing . . .
If you are generating a lot of output you might want to add an additional piece to the set statement:
set serveroutput on size 1000000
The output buffer defaults to 2000 bytes and if you exceed this an exception will be raised that will crash your process. The maximum size you can specify is one million bytes.
Patrick Flahan
flahan_at_leading.net
Baolin ren wrote in message <6dh6s2$7ci$1_at_viper.america.net>...
>Execute the following statement first:
>
>set serverout on
>
>Baolin
>
>Douglas Heydrick wrote in message ...
>>A stored procedure exists on database 'A' (proc). I tried to execute said
>>procedure from database 'B' within SQL*Plus (execute proc_at_A). There are
>>DBMS_OUPUT statements in the stored procedure which do not produce any
>>output from the SQL*Plus session on database 'B'.
>>
>>doug
>>
>>heydrick_at_airmail.net
>>
>>
>>
>
>
Received on Tue Mar 03 1998 - 00:00:00 CST