Re: How to disable foreign key constraints in a stored procedure?

From: DR <dr_at_invalid.address>
Date: Fri, 17 Mar 2006 14:52:29 +0100
Message-ID: <441abf1a$0$15795$14726298@news.sunsite.dk>

<laredotornado_at_zipmail.com> ha scritto nel messaggio news:1142603250.691987.299900_at_e56g2000cwe.googlegroups.com...
> Hi,
>
> Is there another way to do what I'm trying to do in Oracle 9i for
> Solaris? In a stored procedure, I want to disable some foreign key
> constraints, perform some actions, and then re-enable them. However,
> when trying to compile the package, I get the errors. The code is
> below that.
>
> LINE/COL ERROR
> --------
> -----------------------------------------------------------------
> 57/2 PLS-00103: Encountered the symbol "ALTER" when expecting one

Use execute immediate.

Regards,
Dimitre Received on Fri Mar 17 2006 - 07:52:29 CST