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

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.