OraFAQ Forum: SQL & PL/SQL » ORA-02290:Check constraint (APPS.sys

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02290:Check constraint (APPS.sys_c00531421)voileted

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

ORA-02290:Check constraint (APPS.sys_c00531421)voileted [message #156405]

Wed, 25 January 2006 03:47

anil_apps
Messages: 34
Registered: November 2005
Location: India

Member

Hi,
i got the following error

ORA-02290:Check constraint (APPS.sys_c005314211)voileted

what is the meaning of error when iam trying to insert a values into table having Check constraints

thanks

Report message to a moderator

Re: ORA-02290:Check constraint (APPS.sys_c00531421)voileted [message #156407 is a reply to message #156405]

Wed, 25 January 2006 03:51

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

hi,

you can query the user/all_constraints.
regards,

Report message to a moderator

Re: ORA-02290:Check constraint (APPS.sys_c00531421)voileted [message #156415 is a reply to message #156405]

Wed, 25 January 2006 04:16

anil_apps
Messages: 34
Registered: November 2005
Location: India

Member

Can u explain more......

Report message to a moderator

Re: ORA-02290:Check constraint (APPS.sys_c00531421)voileted [message #156416 is a reply to message #156407]

Wed, 25 January 2006 04:17

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

How about looking up the documentation? Read up on Check Constraints. Google the error message.
Jim

Report message to a moderator

Re: ORA-02290:Check constraint (APPS.sys_c00531421)voileted [message #156426 is a reply to message #156405]

Wed, 25 January 2006 04:32

vban2000
Messages: 207
Registered: March 2005

Senior Member

SELECT *
FROM   user_constraints
WHERE  owner = 'APPS'
AND	   CONSTRAINT_NAME = 'SYS_C005314211'

you will find table_name which is having the constraint, the condition of the constraint..

from there.. you should be able to find out the problem...

Report message to a moderator

Previous Topic:	ORACLE (CSR/CRFC) 8i Bugs
Next Topic:	Query related to order in result

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:39:33 CDT 2024