Oracle | DBMS_INTERNAL

Oracle DBMS_INTERNAL_TRIGGER 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 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_SNAP_INTERNAL
DBA_OBJECT_TABLES	DBMS_REPUTIL	DBMS_SYSTEM
DBMS_ASSERT	DBMS_SNAPSHOT_KKXRCA	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	INVALIDATE_LIBRARY_CACHE	MAKE
GET_UGAKNT	IS_NESTED_TABLE	SET_UGAKNT

DESTROY

Undocumented

Overload 1 dbms_internal_trigger.destroy( canon_sname IN VARCHAR2, canon_oname IN VARCHAR2, trigger_type IN CHAR);

exec dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE');

          
      *

      ORA-24331: user buffer too small

Overload 2 dbms_internal_trigger.destroy( canon_sname IN VARCHAR2, canon_oname IN VARCHAR2, trigger_type IN CHAR, expact_entry IN BOOLEAN);

exec dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE', FALSE);

          
      *

      ORA-24331: user buffer too small

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;

      /

      F

      

      PL/SQL procedure successfully completed.

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

      

      PL/SQL procedure successfully completed.

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;

      /

      F

      

      PL/SQL procedure successfully completed.

MAKE

Undocumented

Overload 1 dbms_internal_trigger.make( canon_sname IN VARCHAR2, canon_oname IN VARCHAR2, trigger_type IN CHAR);

exec dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE');

          
      *

      ORA-24331: user buffer too small

Overload 2 dbms_internal_trigger.make( canon_sname IN VARCHAR2, canon_oname IN VARCHAR2, trigger_type IN CHAR, expact_entry IN BOOLEAN);

exec dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE', FALSE);

          
      *

      ORA-24331: user buffer too small

SET_UGAKNT

Undocumented dbms_internal_trigger.set_ugaknt( set_ugaknt_bitmask IN NUMBER, set_ugaknt_turn_on IN BOOLEAN);

exec dbms_internal_trigger.set_ugaknt(999, FALSE);

      

      PL/SQL procedure successfully completed.

      

      exec dbms_internal_trigger.set_ugaknt(999, TRUE);

      

      PL/SQL procedure successfully completed.