How Do You Insert Large Blobs Into Oracle 10G Using System.Data.OracleClient?

Posted by discwiz on Stack Overflow See other posts from Stack Overflow or by discwiz
Published on 2010-03-26T15:23:53Z Indexed on 2010/03/26 15:53 UTC
Read the original article Hit count: 501

Trying to insert 315K Gif files into an Oracle 10g database. Everytime I get this error "ora-01460: unimplemented or unreasonable conversion requested" whe I run the stored procedure. It appears that there is a 32K limit if I use a stored procedure. I read online that this does not apply if you are doing a direct insert, but I do not know how to create the insert string for a Byte Array. This is a thick client running on the server so not worried about SQL Injection attacks.

Any help would be greatly appreciated. FYI, code in vb.net.

Thanks,

Dave

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about oracle10g