Re: Help with JDBC trace.

From: Fred Tilly <>
Date: Wed, 9 Sep 2009 06:35:05 +0000 (GMT)
Message-ID: <>


The varchar2 parameters as defined in JAVA using:

st.registerOutParameter(2, Types.

And the maximum size of the data column in the table being called is varchar2(500)

We are using the thin JDBC driver for 10g.



It looks to me like you are trying to shove 10lbs of data into a 9.99 lb box. Look at the datatype of the column and make sure that you are registering the correct type. Also, any more data that you can share would be great.

WGB -----Original Message-----
[] On Behalf Of Fred Tilly Sent: Tuesday, September 08, 2009 9:47 AM To:
Subject: Help with JDBC trace.


Looking through a JDBC trace file I see the following SEVERE message, does anyone know what it means.

08-Sep-2009 14:47:38 oracle.jdbc.driver.OracleCallableStatement registerOutParameter
INFO: OracleCallableStatement.registerOutParameter(paramIndex=2, sqlType=12, scale=0, maxLength=-1)
08-Sep-2009 14:47:38 oracle.jdbc.driver..T4CCallableStatement allocateAccessor
oracle.jdbc.driver.T4CCallableStatement.allocateAccessors:return: oracle.jdbc.driver.T4CVarcharAccessor_at_19616c7, statement=oracle.jdbc.driver.T4CCallableStatement_at_b166b5, outBind=true, internalType=1, internalTypeMaxLength=32512, isStream=false, formOfUse=1, internalOtype=null, externalType=12, internalTypeName=null, columnName=null, describeType=0, describeMaxLength=0, nullable=false,

precision=0, scale=0, flags=0, contflag=0, total_elems=0,
describeOtype=null, describeTypeName=null, rowSpaceByte=null,
rowSpaceChar=null, rowSpaceIndicator=null, columnIndex=0, lengthIndex=0,
indicatorIndex=0, byteLength=0, charLength=32513




Received on Wed Sep 09 2009 - 01:35:05 CDT

Original text of this message