I have a procedure as below to disable triggers. When I execute only the first trigger is disabled. Rest of the triggers are not disabled. But when executing the same code as pl/sql by replacing the "PROCEDURE disable_trigger AS" to declare and run a PL/SQL script it disables all triggers.
WHERE owner = 'EDWDM';
build_sql VARCHAR2 (500);
FOR tc IN trigger_cur
'ALTER TRIGGER SIEBEL.' || tc.trigger_name || ' DISABLE';
EXECUTE IMMEDIATE (build_sql);
Thank you for the help
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.