Oracle | LTDTRG

Oracle LTDTRG 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 Workspace Management Triggers Utilities

AUTHID CURRENT_USER

Dependencies

ALL_INDEXES	LTRIC	WM$COLUMN_PROPS_USER
ALL_IND_COLUMNS	LTUTIL	WM$CONSTRAINTS_TABLE
ALL_IND_EXPRESSIONS	LT_CTX_PKG	WM$DBA_TAB_COLS
ALL_NESTED_TABLES	OWM_ASSERT_PKG	WM$NESTED_COLUMNS_TABLE_USER
DBMS_LOB	OWM_DDL_PKG	WM$RIC_TABLE_USER
LT	OWM_DYNSQL_ACCESS	WM$UDTRIG_INFO
LTADM	PLITBLM	WM$UDTRIG_INFO_USER
LTDEFINER	UD_TRIGS	WM_DDL_UTIL

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/owmdtrgs.plb

Subprograms

Undocumented ltdtrg.addNewToDefn( s IN VARCHAR2, colstr IN VARCHAR2, prefix IN VARCHAR2);

TBD

CREATETRIGGERS

Undocumented ltdtrg.createTriggers( owner_name_var IN VARCHAR2, table_name_var IN VARCHAR2, colstr_var IN VARCHAR2, keycols_var IN VARCHAR2, notifyconflicts IN BOOLEAN, ric_sql_ins IN CLOB, ric_sql_upd IN CLOB, ric_sql_del IN CLOB, vtid IN NUMBER, dispatchername_var IN VARCHAR2, actualstr IN VARCHAR2, actualstr_io IN VARCHAR2, setclause IN VARCHAR2, insertstr_io IN VARCHAR2, vardecls IN VARCHAR2, keycols_nv_var IN VARCHAR2, bir IN BOOLEAN, air IN BOOLEAN, bur IN BOOLEAN, aur IN BOOLEAN, bdr IN BOOLEAN, adr IN BOOLEAN, hist IN VARCHAR2, vt_option IN NUMBER, buffer_code IN BOOLEAN);

TBD

TRIGGERSELECTCLAUSE

Undocumented ltdtrg.triggerSelectClause( owner_name_var IN VARCHAR2, table_name IN VARCHAR2, verlist IN BOOLEAN) RETURN VARCHAR2;

SELECT wmsys.ltdtrg.triggerSelectClause('C##SH', 'SALES');

             *

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

      

      sho user

      USER is "WMSYS"

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated: