ORA-01460 Error
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Ramkumar_Sundaram
Posted On:   Wednesday, February 18, 2004 01:11 AM

Hi I get the following error while trying to insert a file into a BLOB field via JDBC API. The error comes if and only if the file size exceeds 32512 bytes. The Driver that I use is OCI driver and the oracle version is 9.2. Given below is the log and stack trace. Would appreciate if you could help in figuring out the issue. Thanks & Regards Ramkumar ============================================== File available Length of Blob file : 32513 java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)    More>>

			
Hi

I get the following error while trying to
insert a file into a BLOB field via JDBC API.
The error comes if and only if the file size
exceeds 32512 bytes.

The Driver that I use is OCI driver
and the oracle version is 9.2.
Given below is the log and stack trace.

Would appreciate if you could help in
figuring out the issue.

Thanks & Regards
Ramkumar

==============================================
File available
Length of Blob file : 32513
java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2337)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1744)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1905)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2877)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:684)
at BlobTestProc.insertBlob(BlobTestProc.java:182)
at BlobTestProc.main(BlobTestProc.java:77)
Exception in thread "main"
=============================================

   <<Less
About | Sitemap | Contact