April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed Systems
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,
Start your free trial
Name
DBMS_DEFER_SYS.DELETE_TRAN
Synopsis
The DELETE_TRAN procedure deletes deferred transactions. You might want to do this if you have applied the call manually or if you remove a node from your environment. The procedure deletes the call from the DEFTRANDEST data dictionary view and also from DEFCALLDEST (if it is an RPC). If the original call has been applied to all other destinations, then the procedure also removes the entries from DEFCALL and DEFTRAN.
PROCEDURE DBMS_DEFER_SYS.DELETE_TRAN
(deferred_tran_id IN VARCHAR2,
deferred_tran_db IN VARCHAR2,
destination IN VARCHAR2);There are no restrictions on calling DELETE_TRAN.
Parameters
Parameter Name | Description |
|---|---|
deferred_tran_id | ID from the DEFTRAN data dictionary view of the transaction to be deleted from DEFERROR. If NULL, all entries for the specified deferred_tran_db and destination are deleted. |
deferred_tran_db | Global name of the originating database. If NULL, all entries for the specified deferred_tran_id and destination are deleted. |
destination | Global name of the destination database. If NULL, all entries for the specified deferred_tran_id and deferred_tran_db are deleted. |
Exceptions
Exception Name | Number | Description |
|---|---|---|
NO_DATA_FOUND | –01403 | Specified deferred_tran_id does not exist, specified deferred_tran_db does not exist, or specified destination does not exist. |