[Home] [Help]
484: --
485: -- Fetch the table name from from RDBMS data dictionary views
486: CURSOR get_trigger(cp_name IN VARCHAR2) IS
487: SELECT atr.table_name
488: FROM user_triggers atr
489: WHERE trigger_name = cp_name;
490: --
491: l_tabl VARCHAR2(50);
492: --
546: --
547: -- Get trigger information from the Oracle data dictionary
548: CURSOR get_trigger(cp_name IN VARCHAR2) IS
549: SELECT 'Y'
550: FROM user_triggers
551: WHERE trigger_name = cp_name;
552: --
553: l_rc VARCHAR2(1);
554: --