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

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