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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_APPLY_ADM_IVK
DBMS_APPLY_HANDLER_ADM
DBMS_APPLY_HANDLER_INTERNAL
DBMS_APPLY_PROCESS
What's New In 19c
What's New In 20c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx