Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> VARRAY size limitation problems (restricted to less than 4096 elements)

VARRAY size limitation problems (restricted to less than 4096 elements)

From: Dermot <dermotm_at_amdocs.com>
Date: 28 Aug 2001 07:29:38 -0700
Message-ID: <b7d6850e.0108280629.148d375b@posting.google.com>


Hi Guys,

I have been using VARRAYs thru Java to upload data to a table. Unfortunately, if I make the VARRAY size greater than 4095, the following error transpires:



Error in insertData() method!
java.sql.SQLException: ORA-00600: internal error code, arguments:
[12760], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [kodpunp1], [], [], [], [],
[], [], []

ORA-00600: internal error code, arguments: [kope2upic954], [], [], [],
[], [], [], []

ORA-00600: internal error code, arguments: [kodpunp1], [], [], [], [],
[], [], []

ORA-00600: internal error code, arguments: [kope2upic954], [], [], [],
[], [], [], []
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute
===================================================================

The Oracle versions being used are:
Oracle server 8.1.7
Oracle client 8.0.6

As a result, the driver(s) being used for the Connection are jdbc:oracle:thin rather than jdbc:oracle:oci8

Any Suggestions would be greatly appreciated,

Thank-You in Advance,

D Received on Tue Aug 28 2001 - 09:29:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US