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!

How to disable a trigger in procedure

IwawaOct 2 2008 — edited Jul 8 2009

Hi to All,

I need at begin of my stored procedure disable a table trigger and enable the same trigger at end of procedure. The Oracle version is 10g.

How can I perform this ? Can You suggest a code ?

I hope in your help.

Best regards
Gaetano

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2009

Added on Oct 2 2008

8 comments

8,543 views