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