How do I set a maximum length (in characters) of a CLOB field
BraykovJun 28 2005 — edited Jun 28 2005Hi,
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!