Oracle DBMS_INTERNAL_TRIGGER
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Undocumented but provides support for the DBMS_ITRIGGER_UTL package and affects trigger functionality in materialized views, and advanced and streams replication.
AUTHID DEFINER
Dependencies
DBA_NESTED_TABLES DBMS_ITRIGGER_UTL DBMS_STREAMS_ADM_IVK
DBA_OBJECT_TABLES DBMS_REPUTIL DBMS_STREAMS_ADM_UTL_INVOK
DBMS_ASSERT DBMS_SNAPSHOT_KKXRCA DBMS_SYSTEM
DBMS_CDC_IMPDP DBMS_SNAP_INTERNAL DBMS_UTILITY
Documented No
Exceptions
Error Code Reason
ORA-24331 User buffer too small
First Available Not known
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvthitr.plb
Subprograms
 
DESTROY
Undocumented

Overload 1
dbms_internal_trigger.destroy(
canon_sname  IN VARCHAR2,
canon_oname  IN VARCHAR2,
trigger_type IN CHAR);
SQL> exec dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE');
BEGIN dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE'); END;
*
ERROR at line 1:
ORA-24331: user buffer too small
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 79
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 157
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 201
ORA-06512: at line 1
Overload 2 dbms_internal_trigger.destroy(
canon_sname  IN VARCHAR2,
canon_oname  IN VARCHAR2,
trigger_type IN CHAR,
expact_entry IN BOOLEAN);
SQL> exec dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE', FALSE);
BEGIN dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE'); END;
*
ERROR at line 1:
ORA-24331: user buffer too small
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 79
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 157
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 201
ORA-06512: at line 1
 
GET_UGAKNT
Undocumented dbms_internal_trigger.get_ugaknt(bitmask IN NUMBER) RETURN BOOLEAN;
BEGIN
  IF dbms_internal_trigger.get_ugaknt(0) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
 
INVALIDATE_LIBRARY_CACHE
Invalidates the named object in the library cache dbms_internal_trigger.invalidate_library_cache(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
exec dbms_internal_trigger.invalidate_library_cache('UWCLASS', 'SERVERS');
 
IS_NESTED_TABLE
Returns TRUE if the named table is a nested table dbms_internal_trigger.is_nested_table(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
  IF dbms_internal_trigger.is_nested_table('UWCLASS', '-SERVERS') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
 
MAKE
Undocumented

Overload 1
dbms_internal_trigger.make(
canon_sname  IN VARCHAR2,
canon_oname  IN VARCHAR2,
trigger_type IN CHAR);
SQL> exec dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE');
BEGIN dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE'); END;
*
ERROR at line 1:
ORA-24331: user buffer too small
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 79
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 129
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 180
ORA-06512: at line 1
Overload 2 dbms_internal_trigger.make(
canon_sname  IN VARCHAR2,
canon_oname  IN VARCHAR2,
trigger_type IN CHAR,
expact_entry IN BOOLEAN);
SQL> exec dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE', FALSE);
BEGIN dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE', FALSE); END;
*
ERROR at line 1:
ORA-24331: user buffer too small
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 79
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 129
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 180
ORA-06512: at line 1
 
SET_UGAKNT
Undocumented dbms_internal_trigger.set_ugaknt(
set_ugaknt_bitmask IN NUMBER,
set_ugaknt_turn_on IN BOOLEAN);
TBD

Related Topics
 
 
 
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved