SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I disable a constraint in a stored procedure

581723Jun 21 2007 — edited Jun 21 2007

Hi,

I wish to disable a constraint and then enable after I do a certain insert into a database, In my procedure I put the 'ALTER ..DISABLE' command straight after the begin and the the 'ALTER..ENABLE' just before the exit command but I keep getting a compile error. Any suggestions?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2007

Added on Jun 21 2007

1 comment

1,004 views