Deferred constraint question

In Oracle 8.0.5.1, I have defined a table with a foreign key constraint which is DEFERRABLE INITIALLY IMMEDIATE. From within SQL*Plus, I can use the "set constraint" statement to make the constraint deferred for the length of a transaction. This works just as described in the Oracle documentation (i.e. the constraint is not enforced until a commit is issued). I can't figure out how to make the constraint deferred from within PL/SQL, however. Is there a supplied package which sets a constraint to deferrable, just like the "set constraint" statement does?

Any information would be greatly appreciated.

Thank you in advance,

Jim Jenkinson
jjenkins_at_castle.net Received on Tue Jun 22 1999 - 20:36:23 CDT