Hi,
I have placed an unique contraint on a table and made it DEFERRABLE (that is initially immediate).
Now I'm writing a package where I want to make this constraint "Deferred".
So I write the following inside a procedure before the DML code:
[quote]PL/SQL: ORA-00922: missing or invalid option
[/quote]What am I doing wrong? Can't you change this constraint inside a package?
Any help is very much appreciated.
Thank you,
Roeland