How to determine the Oracle session's constraint state?

From: John Peterson <>
Date: Mon, 8 Feb 2010 10:08:48 -0700
Message-ID: <>


First time poster in this forum -- please forgive me if this is the wrong place for my question. I've exhausted a web search on this issue, and was hoping that this might be a more targeted approach.

I am trying to programmatically determine the current session's constraint state (immediate, deferred, or default).

I have a procedure that I'd like to implement which would essentially temporarily set the constraints "deferred" (e.g. SET CONSTRAINTS ALL DEFERRED), perform some work, and then restore the constraint setting to the original state (e.g., immediate). However, I'm having a difficult time identifying how to determine the current state of the constraints.

Any help would be very much appreciated!

Kind regards,

John Peterson   Received on Mon Feb 08 2010 - 11:08:48 CST

Original text of this message