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