Skip to Main Content
Forums

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!

Column of varchar2(4000 char) - Could not insert text of length(with multi-byte chars) less than 400

User_NFKR7Apr 27 2017 — edited Apr 27 2017

I have a table created like this:

create table x_test_char

(comments varchar2(4000 char));

When I try to insert using a pl/sql into that table as below:

pastedImage_0.png

I get this error:

ORA-01461: can bind a LONG value only for insert into a LONG column

How could I insert the above content into the column that is varchar2(4000 char)?
This post has been answered by AndrewSayer on Apr 27 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2017
Added on Apr 27 2017
#general-database-discussions
2 comments
1,094 views