Skip to Main Content

Oracle Database Discussions

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 2000 characters in the Oracle Database table?

2796536Mar 14 2016 — edited Mar 15 2016

Hi Expert,

We are migrating the Lotus Notes data to the CS application database table. We have created a table on the CS application database . Now when we are trying to insert the data we are getting the error for 2 columns which are BLOB data type.

I believe BLOB data type only supports 2000 characters length and the data which we are trying to insert is more than 2000 characters (max it is 65000 character). We are using the below syntax to insert into BLOB datatype,
utl_raw.cast_to_raw(DATA).

Can anyone please help me out on how to insert data more than 2000 characters into the database table?

Thanks,
Nikhil Sanghvi

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2016
Added on Mar 14 2016
7 comments
4,980 views