Re: OLEDB 8.1.7.2

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 09 Jan 2002 19:23:58 +0100
Message-ID: <7i2p3u044e32plbda0gfr1bg8hvorfis3k@4ax.com>

On 9 Jan 2002 08:25:05 -0800, hdeshpande_at_carlson.com (Harish Deshpande) wrote:

>Hi,
>
>I have developed a VB application using OLEDB 8.1.7.2 driver. The
>application connects to the database performs a transaction and
>disconnects. Things work well except when we do stress testing. This
>is when I get the error "ORA-20000: ORU-10027: buffer overflow, limit
>of 1000000 bytes". The application does close the connection at the
>end of each request. I however suspect the OLEDB driver persists the
>connection for a while and hence during stress testing the above limit
>is reached for the error to occur. The VB application calls stored
>procedures that do write output.
>
>Any help/suggestions is very much appreciated.
>
>Harish

The code you are running contains calls to dbms_output. Evidently they were included for debugging purposes and you need to remove them.
The upper limit for dbms_output is 1000000 bytes, you can't further increase it. If that is a problem you need to replace your calls to dbms_output by calls to utl_file. Do not forget to set the init.ora parameter utl_file_dir and bounce the database.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jan 09 2002 - 12:23:58 CST