[Home] [Help]
2184: PROCEDURE gen_alter_trigger (p_schema IN VARCHAR2)
2185: IS
2186: CURSOR trg_csr(l_owner VARCHAR2) IS
2187: SELECT dt.owner, dt.trigger_name
2188: FROM dba_triggers dt
2189: WHERE table_owner = l_owner
2190: AND status = 'ENABLED';
2191: l_string VARCHAR2(4000);
2192: l_lineno NUMBER;