Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> VARRAY size limitation problems (restricted to less than 4096 elements)
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:
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