Re: DBMS_SQL question

In my testing, enable/disable did not work. Buffer ovrflow still occurs. get_line may clear last line from buffer but if intention is to get everything to stdout - what purpose does it server to get a line out from buffer by using get_line ? How do you put that line back onto stdout. If there is any real way of getting around 1M buffer limit for put_line, please let me know.

Hadar Paiss <hpaiss_at_netvision.net.il> wrote:

>New Age wrote:
>>
>> Hi,
>> I have a package wherein I am using DBMS_SQL. After repeated use of
>> this package, at some point, I recieve a error message that
>> DBMS_OUTPUT buffer overflow. Does any one has faced this problem ? In
>> order to correct this, I had to follow the following method:
>>
>> DBMS_OUTPUT.enable (5000);
>> ...
>> ...
>> .. DBMS_SQL code
>> ---
>> ---
>> DBMS_OUTPUT.disable;
>>
>> I am using PowerBuilder as front end. It may cause this error. I am
>> not sure.
>>
>> Prabha
 

>Try : dbms_output.enable(100000)
>5000 bytes are in many time too small for the dbms_output buffer.
>Also note that you should clear the buffer from time to time, by reading
>from it by dbms_output.get_line
> Hadar Paiss
Received on Sun Feb 25 1996 - 00:00:00 CET