Name
DBMS_DEFER_SYS.COPY (Oracle7 only)
Synopsis
The COPY procedure copies a specified deferred transaction. Oracle queues the copied transaction to the new destinations that you specify.
PROCEDURE DBMS_DEFER_SYS.COPY
(deferred_tran_id IN VARCHAR2,
deferred_tran_db IN VARCHAR2,
destination_list IN dbms_defer.node_list_t,
destination_count IN BINARY_INTEGER);There are no restrictions on calling COPY.
Parameters
Parameter Name | Description |
|---|---|
deferred_tran_id | ID from the DEFTRAN data dictionary view to be copied |
deferred_tran_db | Global name of the originating database |
destination_list | PL/SQL table listing global names of databases to which the transaction is to be sent |
destination_count | Number of entries in destination_list |
Exceptions
Exception Name | Number | Description |
|---|---|---|
NO_DATA_FOUND | –01403 | Specified deferred_tran_id does not exist. |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access