DISBALE/ENABLE A TRIGGER IN THE PROCEDURE

[marist89]

Originally posted by jovery
You can issue an execute immediate similar to the following:

sql_code := 'ALTER TRIGGER user.xyz DISABLE;';
execute immediate sql_code;

Regards

sql_code := 'ALTER TRIGGER user.xyz DISABLE';