Oracle | UD

Oracle UD_TRIGS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented

AUTHID DEFINER

Dependencies

ALL_NESTED_TABLES	LTDDL	OWM_DYNSQL_ACCESS
ALL_TRIGGERS	LTDTRG	OWM_MIG_PKG
ALL_USERS	LTRIC	PLITBLM
DBA_CONSTRAINTS	LTUTIL	WM$DBA_TAB_COLS
DBA_CONS_COLUMNS	LT_EXPORT_PKG	WM$RIC_TRIGGERS_TABLE
DBA_DEPENDENCIES	OBJ$	WM$UDTRIG_DISPATCHER_SEQUENCE
DBA_TAB_COLS	OWM_ASSERT_PKG	WM$UDTRIG_DISPATCH_PROCS
LTDBMS_LOB	OWM_DDL_PKG	WM$UDTRIG_INFO
LTADM	OWM_DML_PKG	WM_ERROR

Documented No

First Available Not known

Security Model Owned by WMSYS with no privileges granted

Direct access to this package is prevented by means of an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/owmutrgs.plb
{ORACLE_HOME}/rdbms/admin/owmutrgb.plb

Subprograms

DROP_ALL_UDTRIG_DISPATCH_PROCS	INSERTTABLEOWNERNAME	SETGLOBALTRIGGERSETTING
EXISTSTRIGGER	RECREATETRIGPROCSDG	SETTRIGGEREVENTS
GENUDTRIGDISPATCHER	REGENUDTRIGDISPATCHER	SUBSTITUTETABLENAME
GETDISPATCHERINFO	REGENUDTRIGPROCS	TRF_UDTRGS_ON_COMMIT_DDL
GETPARAMSTRS	REMOVEDOUBLEQUOTESINUSERNAME	TRF_UDTRGS_ON_VER_DISABLE
HASOWNERNAMEPREFIX	REPLACEOLDNEW	TRF_UDTRGS_ON_VER_ENABLE

DROP_ALL_UDTRIG_DISPATCH_PROCS

Undocumented ud_trigs.drop_all_udtrig_dispatch_procs( table_owner_v IN VARCHAR2, table_name_v IN VARCHAR2);

TBD

EXISTSTRIGGER

Undocumented ud_trigs.existsTrigger( trigger_owner_var IN VARCHAR2, trigger_name_var IN VARCHAR2) RETURN BOOLEAN;

TBD

GENUDTRIGDISPATCHER

Undocumented ud_trigs.genUDTrigDispatcher( table_owner_v IN VARCHAR2, table_name_v IN VARCHAR2, formal_str IN VARCHAR2, bind_formal_str IN VARCHAR2, bind_actual_str IN VARCHAR2, io_flag IN BOOLEAN, buffercode IN BOOLEAN, generateundo IN BOOLEAN);

TBD

GETDISPATCHERINFO

Undocumented ud_trigs.getDispatcherInfo( tab_owner IN VARCHAR2, tab_name IN VARCHAR2, dispatchername OUT VARCHAR2, actual_str OUT VARCHAR2, actual_str_io OUT VARCHAR2, set_clause OUT VARCHAR2, insertstr_io OUT VARCHAR2, var_decls OUT VARCHAR2, bir OUT BOOLEAN, air OUT BOOLEAN, bur OUT BOOLEAN, 1aur OUT BOOLEAN, 1bdr OUT BOOLEAN, 1adr OUT BOOLEAN);

TBD

GETPARAMSTRS

Undocumented ud_trigs.getParamStrs( tab_owner IN VARCHAR2, tab_name IN VARCHAR2, actual_str OUT VARCHAR2, formal_str OUT VARCHAR2, bind_formal_str OUT VARCHAR2, bind_actual_str OUT VARCHAR2, actual_str_io OUT VARCHAR2, formal_str_io OUT VARCHAR2, bind_actual_str_io OUT VARCHAR2, set_clause OUT VARCHAR2, insertstr_io OUT VARCHAR2, 1var_decls OUT VARCHAR2, 1var_decls_proc OUT VARCHAR2, 1column_comp_str OUT VARCHAR2);

TBD

HASOWNERNAMEPREFIX

Undocumented ud_trigs.hasOwnerNamePrefix( str IN VARCHAR2, owner_name IN VARCHAR2) RETURN BOOLEAN;

conn wmsys

      Password:

      

      BEGIN

        IF ud_trigs.hasOwnerNamePrefix('C##UWCLASS.SERVERS', 'C##UWCLASS') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

       IF ud_trigs.hasOwnerNamePrefix('C##UWCLASS.SERVERS', 'C##UWCLASS') THEN

          *

      ERROR at line 2:

      ORA-06550: line 2, column 6:

      PLS-00904: insufficient privilege to access object UD_TRIGS

      ORA-06550: line 2, column 3:

      PL/SQL: Statement ignored

INSERTTABLEOWNERNAME

Undocumented ud_trigs.insertTableOwnerName( table_owner IN VARCHAR2, table_name IN VARCHAR2, description IN VARCHAR2) RETURN VARCHAR2,;

conn wmsys

      Password:

      

      SELECT wmsys.ud_trigs.insertTableOwnerName('C##UWCLASS', 'SERVERS', 'Test')

      FROM dual;

      SELECT wmsys.ud_trigs.insertTableOwnerName('C##UWCLASS', 'SERVERS', 'Test')

             *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object UD_TRIGS

RECREATETRIGPROCSDG

Undocumented ud_trigs.recreateTrigProcsDG( table_owner_v IN VARCHAR2, table_name_v IN VARCHAR2, to_version IN VARCHAR2);

TBD

REGENUDTRIGDISPATCHER

Undocumented ud_trigs.regenUDTrigDispatcher( table_owner_v IN VARCHAR2, table_name_v IN VARCHAR2, buffercode IN BOOLEAN);

TBD

REGENUDTRIGPROCS

Undocumented ud_trigs.regenUDTrigPros( table_owner_v IN VARCHAR2, table_name_v IN VARCHAR2, buffercode IN BOOLEAN);

TBD

REMOVEDOUBLEQUOTESINUSERNAME

Undocumented ud_trigs.removeDoubleQuotesInUserName( description_var IN VARCHAR2, trig_owner_name IN VARCHAR2, table_owner_name IN VARCHAR2, table_name IN VARCHAR2) RETURN VARCHAR2,;

conn wmsys

      Password:

      

      SELECT wmsys.ud_trigs.removeDoubleQuotesInUserName('"X"', 
      '"C##UWCLASS"', '"C##UWCLASS"', '"TESTTAB"')

      FROM dual;

      SELECT 
      wmsys.ud_trigs.removeDoubleQuotesInUserName('"X"', '"C##UWCLASS"', '"C##UWCLASS"', '"TESTTAB"')

             *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object UD_TRIGS

REPLACEOLDNEW

Undocumented ud_trigs.replaceOldNew( str IN VARCHAR2, old_str IN VARCHAR2, new_str IN VARCHAR2, newchar IN VARCHAR2) RETURN VARCHAR2,;

conn wmsys

      Password:

      

      SELECT wmsys.ud_trigs.replaceOldNew('AA', 'This is a test', 'This was a test', 'X')

      FROM dual;

      SELECT wmsys.ud_trigs.replaceOldNew('AA', 'This is a test', 'This was a test', 'X')

             *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object UD_TRIGS

SETGLOBALTRIGGERSETTING

Undocumented ud_trigs.setGlobalTriggerSetting(value_var IN VARCHAR2);

TBD

SETTRIGGEREVENTS

Undocumented ud_trigs.setTriggerEvents( trigger_owner_var IN VARCHAR2, trigger_name_var IN VARCHAR2, triggereventstab IN TABLE wmsys.ltutil.wm$ident_tab);

TBD

SUBSTITUTETABLENAME

Undocumented ud_trigs.substituteTableName( table_owner IN VARCHAR2, table_name IN VARCHAR2, new_table_name IN VARCHAR2, description IN VARCHAR2) RETURN VARCHAR2,;

TBD

TRF_UDTRGS_ON_COMMIT_DDL

Undocumented ud_trigs.trf_udtrgs_on_commit_ddl( table_owner_v IN VARCHAR2, table_name_v IN VARCHAR2);

TBD

TRF_UDTRGS_ON_VER_DISABLE

Undocumented ud_trigs.trf_udtrgs_on_ver_disable( table_owner_v IN VARCHAR2, table_name_v IN VARCHAR2);

TBD

TRF_UDTRGS_ON_VER_ENABLE

Undocumented ud_trigs.trf_udtrgs_on_ver_enable( table_owner_v IN VARCHAR2, table_name_v IN VARCHAR2, procname OUT VARCHAR2, actual_str OUT VARCHAR2, actual_str_io OUT VARCHAR2, set_clause OUT VARCHAR2, insertstr_io OUT VARCHAR2, var_decls OUT VARCHAR2, bir OUT BOOLEAN, air OUT BOOLEAN, bur OUT BOOLEAN, aur OUT BOOLEAN, bdr OUT BOOLEAN, adr OUT BOOLEAN);

TBD