Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert more than 4000 bytes in BLOB column

user546710Sep 21 2012 — edited Sep 22 2012
Hi all,

My oracle version is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0.

I have checked in google and in this forum also, but did not find the answer.

When inserting into less than 4000 bytes, it is inserting without any issues. If i am inserting more than that, it is throwing
error like this ORA-01460: unimplemented or unreasonable conversion requested.

Can anybody guide me how to do this or link.


Thanks in advance.

Thanks,
Pal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2012
Added on Sep 21 2012
5 comments
1,872 views