Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: "alter table..." in a trigger
On Tue, 19 Feb 2002 17:50:26 +0100, "auxitec e2ia"
<auxitec.e2ia_at_wanadoo.fr> wrote:
>hi,
>
>is it possible to do an "ALTER TABLE TEST.POIL DISABLE CONSTRAINT PK_ESSAI"
>in a trigger ?
>
>Thanks
>
>
>Flavien,
>
>
>
You can do that using execute immediate (8i) or dbms_sql (8.0 and
before)
Your requests raises strong suspicions about the quality of your work.
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Tue Feb 19 2002 - 12:12:38 CST