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 do I set a maximum length (in characters) of a CLOB field

BraykovJun 28 2005 — edited Jun 28 2005
Hi,

I've seen some questions like this around, but I did not find a clear answer.
This is my problem: I want to make my CLOB field to accept a maximum of 32768 characters. This is because I need other data manipulation tools to receive an ORA error when they try to insert or update text larger than 32768.
I tried with an Insert/Update trigger, but I received ORA error that actually means that LOB fields can not be used in update trigger(or something).
Please, help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2005
Added on Jun 28 2005
2 comments
518 views