OraFAQ Forum: SQL & PL/SQL » how can we check constraints after commit statement in oracle9i

Home » SQL & PL/SQL » SQL & PL/SQL » how can we check constraints after commit statement in oracle9i

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

how can we check constraints after commit statement in oracle9i [message #9201]

Sun, 26 October 2003 22:50

Kalyan
Messages: 16
Registered: October 2001

Junior Member

how can we check constraints after commit statement in oracle9i (sql part)at the transaction level the contraints should not be checked

Report message to a moderator

Re: how can we check constraints after commit statement in oracle9i [message #9214 is a reply to message #9201]

Mon, 27 October 2003 10:52

Thiru
Messages: 1089
Registered: May 2002

Senior Member

do you mean you want to validate the constraints at the COMMIT time and not at the statement level ?

use deferred constraints and make them deferrable.

-Thiru

Report message to a moderator

Previous Topic:	procedure parameter
Next Topic:	Trigger issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 10:24:00 CDT 2024