Skip to Main Content

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!

ORA-14552: cannot perform a DDL in a execute immediate - proc

122352Apr 21 2004 — edited Apr 22 2004
Hi All,

I am trying to disable triggers in a stored procedure:

PROCEDURE Alter_trigger_DISBALE
IS
BEGIN
execute immediate ('alter trigger BEI_INS_MY DISABLE');
END;

I get the following error:

ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML

Is there a solution for this problem ?

Best Regards
Friedhold

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 20 2004
Added on Apr 21 2004
2 comments
1,173 views