create or replace procedure admin_enable_alltriggers IS
s_SQL varchar2(400);
cursor c_tables is SELECT trigger_name FROM user_triggers WHERE STATUS LIKE 'DISABLED';
begin
for v_table in c_tables loop
s_SQL := 'alter trigger '||v_table.trigger_name||' enable';
execute immediate s_SQL;
ALTER TRIGGER b$detailreference_nrupdate enable ;
end loop;
end;
s_SQL varchar2(400);
cursor c_tables is SELECT trigger_name FROM user_triggers WHERE STATUS LIKE 'DISABLED';
begin
for v_table in c_tables loop
s_SQL := 'alter trigger '||v_table.trigger_name||' enable';
execute immediate s_SQL;
ALTER TRIGGER b$detailreference_nrupdate enable ;
end loop;
end;