Oracle | UD

Oracle UD_TRIGS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented

AUTHID DEFINER

Dependencies

ALL_CONSTRAINTS	LTDTRG	OWM_MIG_PKG
ALL_CONS_COLUMNS	LTRIC	PLITBLM
ALL_DEPENDENCIES	LTUTIL	WM$DBA_TAB_COLS
ALL_NESTED_TABLES	LT_EXPORT_PKG	WM$RIC_TRIGGERS_TABLE_USER
ALL_TAB_COLS	OBJ$	WM$UDTRIG_DISPAT_PROCS_USER
ALL_TRIGGERS	OWM_ASSERT_PKG	WM$UDTRIG_DISPATCH_PROCS
ALL_USERS	OWM_DDL_PKG	WM$UDTRIG_INFO
LT	OWM_DML_PKG	WM$UDTRIG_INFO_USER
LTADM	OWM_DYNSQL_ACCESS	WM_ERROR
LTDDL

Documented No

First Available Not known

Security Model Owned by WMSYS with no privileges granted

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

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

Subprograms

DROP_ALL_UDTRIG_DISPATCH_PROCS	REGENUDTRIGPROCS
EXISTSTRIGGER	REMOVEDOUBLEQUOTESINUSERNAME
GENUDTRIGDISPATCHER	REPLACEOLDNEW
GETDISPATCHERINFO	SETGLOBALTRIGGERSETTING
GETPARAMSTRS	SETTRIGGEREVENTS
HASOWNERNAMEPREFIX	SUBSTITUTETABLENAME
INSERTTABLEOWNERNAME	TRF_UDTRGS_ON_COMMIT_DDL
RECREATETRIGPROCSDG	TRF_UDTRGS_ON_VER_DISABLE
REGENUDTRIGDISPATCHER	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;

      /

      *

      PLS-00904: insufficient privilege to access object UD_TRIGS

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');

            
      *

      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"');

             *

      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');

             *

      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