OraFAQ Forum: SQL & PL/SQL » Limiting CLOB size (is it even possible)

Home » SQL & PL/SQL » SQL & PL/SQL » Limiting CLOB size (is it even possible)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Limiting CLOB size (is it even possible) [message #7783]

Tue, 08 July 2003 13:29

sridhar
Messages: 119
Registered: December 2001

Senior Member

Is it possible to impose a max size on a field of type CLOB.
thx - S

Report message to a moderator

Re: Limiting CLOB size (is it even possible) [message #7784 is a reply to message #7783]

Tue, 08 July 2003 14:03

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You don't mention what upper limit you are considering, but here is an example with a ridiculously low limit:

sql>create table t (c clob check (length(c) <= 5));
 
Table created.
 
sql>insert into t values ('123');
 
1 row created.
 
sql>insert into t values ('12345');
 
1 row created.
 
sql>insert into t values ('1234567');
insert into t values ('1234567')
*
ERROR at line 1:
ORA-02290: check constraint (SYS_C003672) violated

Report message to a moderator

Previous Topic:	Calling a procedure on another database
Next Topic:	help me please . . .

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 21:08:41 CDT 2024