Oracle | DBMS_APPLY

Oracle DBMS_APPLY_ERROR Version 21c

General Information

Library Note

Morgan's Library Page Header

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 Streams Apply Process Error Handling Internal Support

AUTHID DEFINER

Dependencies

ANYDATA	DBMS_APPLY_ADM_INTERNAL	DBMS_SYS_ERROR
APPLY$_ERROR	DBMS_LOGREP_LIB	STREAMS$_APPLY_PROCESS
APPLY$_ERROR_TXN	DBMS_LOGREP_UTIL	STREAMS$_APPLY_SPILL_MESSAGES
AQ$_QUEUES	DBMS_STANDARD	STREAMS$_APPLY_SPILL_MSGS_PART
AQ$_QUEUE_TABLES	DBMS_STREAMS_ADM_UTL	STREAMS$_APPLY_SPILL_TXN
DBMS_APPLY_ADM	DBMS_STREAMS_DECL	USER$

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvthapp.plb

Subprograms

DELETE_ALL_ERRORS	EXECUTE_ERROR	PROCESS_USER_PROPERTIES
DELETE_ERROR	GET_ERROR_MESSAGE	SET_ERROR_TXN_CHUNK_SIZE
EXECUTE_ALL_ERRORS	GET_ERROR_TXN_CHUNK_SIZE

DELETE_ALL_ERRORS

delete all apply errors dbms_apply_error.delete_all_errors( apply_name IN VARCHAR2, delete_conflict_info IN BOOLEAN, canon_invoker IN VARCHAR2);

TBD

DELETE_ERROR

Delete a specific apply error dbms_dbms_apply_error.delete_error( local_transaction_id IN VARCHAR2, delete_conflict_info IN BOOLEAN, canon_invoker IN VARCHAR2);

TBD

EXECUTE_ALL_ERRORS

Undocumented dbms_apply_error.execute_all_errors( apply_name IN VARCHAR2, execute_as_user IN BOOLEAN, canon_user_name IN VARCHAR2);

TBD

EXECUTE_ERROR

Undocumented dbms_apply_error.execute_error( local_transaction_id IN VARCHAR2, execute_as_user IN BOOLEAN, canon_user_name IN VARCHAR2, canon_user_procedure IN VARCHAR2);

TBD

GET_ERROR_MESSAGE

Returns the current apply error message dbms_apply_error.get_error_message( message_number IN NUMBER, local_transaction_id IN VARCHAR2, destination_queue_name OUT VARCHAR2, execute OUT BOOLEAN) RETURN XMLTYPE;

TBD

GET_ERROR_TXN_CHUNK_SIZE

Returns the chunk size for apply errors (the default is 100) dbms_apply_error.get_error_txn_chunk_size RETURN NUMBER;

SELECT dbms_apply_error.get_error_txn_chunk_size

      FROM dual;

      

      GET_ERROR_TXN_CHUNK_SIZE

      ------------------------

                           100

PROCESS_USER_PROPERTIES

Undocumented dbms_apply_error.process_user_properties( anydata_msg IN XMLTYPE, destination_queue_name OUT VARCHAR2, execute OUT BOOLEAN);

TBD

SET_ERROR_TXN_CHUNK_SIZE

Sets the chunk size for apply errors (the default is 100) dbms_apply_error.set_error_txn_chunk_size(chunk_size IN NUMBER);

exec dbms_apply_error.set_error_txn_chunk_size(128);

      

      PL/SQL procedure successfully completed.

      

      SELECT dbms_apply_error.get_error_txn_chunk_size

      FROM dual;

      

      GET_ERROR_TXN_CHUNK_SIZE

      ------------------------

                           128