Skip to Main Content

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!

Automatic trim of too long strings

817480Nov 22 2010 — edited Nov 23 2010
Hi,

if I try to insert a too long string value into a VARCHAR column, I get the error ORA-12899.

Is it possible to set the Oracle database so that too long strings get trimmed automatically?

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2010
Added on Nov 22 2010
8 comments
3,589 views