ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Undocumented but provides support for the DBMS_ITRIGGER_UTL package and affects trigger functionality in materialized views, and advanced and streams replication.
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');
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);
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 159
ORA-06512: at line 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');
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);
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 131
ORA-06512: at line 1