Oracle DBMS_APPLY

Oracle DBMS_APPLY_ERROR Version 19c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Streams Apply Process Error Handling Internal Support

Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.

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