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 is now availble. If you haven't you downloaded already: Why?

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