FAQ
All,

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
SEVERE: 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

Thanks

Fred

Search Discussions

  • Mathias Magnusson at Sep 8, 2009 at 4:03 pm
    JDBC is not my area, but is it not interesting that CharLength is one
    higher than InteralTypeMaxLength? I'd have thought the limit would be
    32K (32768), but rather it seems to be limited to slightly less. Type
    1 would probably be varchar2, which I think is what a bind of type 1
    is.

    But then again, the problem may be something completely different that
    someone more used to JDBC traces will be able to address.

    Mathias
    On Tue, Sep 8, 2009 at 4:47 PM, Fred Tilly wrote:
    All,

    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
    SEVERE: 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

    Thanks

    Fred

    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l
  • Fred Tilly at Sep 9, 2009 at 6:35 am
    Hi,

    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.

    Thanks

    FredVARCHAR);

    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-----
    From: oracle-l-bounce_at_freelists.org
    [oracle-l-bounce_at_freelists.org] On Behalf Of Fred Tilly
    Sent: Tuesday, September 08, 2009 9:47 AM
    To: oracle-l@freelists.org
    Subject: Help with JDBC trace.

    All,

    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
    SEVERE:

    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

    Thanks

    Fred

    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 8, '09 at 2:47p
activeSep 9, '09 at 6:35a
posts3
users2
websiteoracle.com

2 users in discussion

Fred Tilly: 2 posts Mathias Magnusson: 1 post

People

Translate

site design / logo © 2022 Grokbase