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

"Dermot" <dermotm_at_amdocs.com> wrote in message news:b7d6850e.0108280629.148d375b_at_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(OraclePreparedState ment.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

ORA-600 =======> Call support
These are untrapped errors which normally don't surface, and no one can resolve them except support.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 28 2001 - 12:14:08 CDT