Re: DBMS_SQL question

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 Sat Feb 24 1996 - 00:00:00 CET