Oracle | DBMS_APPLY

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

AUTHID DEFINER

Dependencies

ANYDATA	DBMS_STANDARD
APPLY$_ERROR	DBMS_STREAMS_ADM_UTL
APPLY$_ERROR_TXN	DBMS_STREAMS_DECL
AQ$_QUEUES	DBMS_SYS_ERROR
AQ$_QUEUE_TABLES	STREAMS$_APPLY_PROCESS
DBMS_APPLY_ADM	STREAMS$_APPLY_SPILL_MESSAGES
DBMS_APPLY_ADM_INTERNAL	STREAMS$_APPLY_SPILL_MSGS_PART
DBMS_LOGREP_LIB	STREAMS$_APPLY_SPILL_TXN
DBMS_LOGREP_UTIL	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;

      

      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;

      

      GET_ERROR_TXN_CHUNK_SIZE

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

                           128