ORU-10027 buffer overflow with JDBC classes12.zip driver

From: Neal Gran <neal.gran_at_metaserver.com>
Date: 11 Feb 2002 09:13:45 -0800
Message-ID: <724e0737.0202110913.1c5d995d@posting.google.com>

I am converting an application and switching Oracle drivers from classes111.zip to classes12.zip to connect to an oracle 8.0.5 database via JDBC. The issue that I am running into is that I am getting a ORA-20000 ORU-10027 buffer overflow error frequently when I run stored procedures. I have a command within the Proc:

DBMS_OUTPUT.ENABLE(10000000); so the buffer is as large as possible. My understanding is that if the if I do not issue a "set serveroutput ON" command that the default for PLSQL code is for output to be turned off.

When running these procedures using the old driver I never got the buffer overflow errors. Can someone tell me if the default for serveroutput has changed between the two driver versions, and if there is a way that I can turn off the output for the JDBC calls that I am executing?

Thanks

-Neal Gran (neal.gran_at_metaserver.com)
Application Engineer
Metaserver Inc.
www.metaserver.com Received on Mon Feb 11 2002 - 11:13:45 CST