Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

GETCHUNKSIZE must be declared error ? Oracle + JDBC

7 views
Skip to first unread message

Caroline O'Reilly

unread,
May 19, 1999, 3:00:00 AM5/19/99
to

Hi,

I just can't seem to get even the Oracle demos, to work with JDBC
and Oracle, the ones that manipulate LOBs that is,.....has anyone been
able to get even the example going ??

http://www.oracle.com/java/codesamples/jdbc/index.html
LobExample.java

I keep running up against this error. I hope
someone knows what it means !!!

bash-2.01$ java LobExample
Dumping lobs
java.sql.SQLException: ORA-06550: line 1, column 22:
PLS-00302: component 'GETCHUNKSIZE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java)
at oracle.sql.BLOB.plsql_getChunkSize(BLOB.java)
at oracle.jdbc.ttc7.TTC7Protocol.getLobChunkSize(TTC7Protocol.java)
at oracle.sql.BLOB.getChunkSize(BLOB.java)
at oracle.sql.BLOB.getBufferSize(BLOB.java)
at oracle.sql.BLOB.getBinaryStream(BLOB.java)
at LobExample.dumpBlob(LobExample.java:120)
at LobExample.main(LobExample.java:61)

thanks,
Caroline
--

Caroline

0 new messages