Skip to Main Content
Oracle Distributed Systems
book

Oracle Distributed Systems

by Charles Dye
April 1999
Intermediate to advanced content levelIntermediate to advanced
552 pages
15h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle Distributed Systems

Name

DBMS_DEFER_SYS.EXECUTE_ERROR

Synopsis

The EXECUTE_ERROR procedure executes transactions in the DEFERROR data dictionary view after the cause of the error has been resolved. As with the DELETE_ERROR and DELETE_TRAN procedures, you may pass NULLs to indicate wildcards.

PROCEDURE DBMS_DEFER_SYS.EXECUTE_ERROR
   (deferred_tran_id IN VARCHAR2,
    deferred_tran_db IN VARCHAR2,
    destination      IN VARCHAR2);

Parameters

Parameter Name

Description

deferred_tran_id

ID of transaction in the DEFERROR data dictionary view

deferred_tran_db

Global name of database that originated or copied the transaction originally

destination

Global name of destination database

Exceptions

Exception Name

Number

Description

ORA-24275

–24275

destination is NULL, or deferred_tran_id and deferred_tran_db are neither both NULL nor both NOT NULL.

If execution stops because of an exception, the EXECUTE_ERROR procedure raises the last exception encountered.

Restrictions

  • The destination parameter may not be NULL.

  • The deferred_tran_id and deferred_tran_db parameters must either both be NULL or both be NOT NULL. If they are NULL, all transactions in DEFERROR destined for destination are applied.

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.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Expert Oracle RAC 12c

Expert Oracle RAC 12c

Syed Jaffar Hussain, Tariq Farooq, Riyaj Shamsudeen, Kai Yu
Expert Oracle Exadata, Second Edition

Expert Oracle Exadata, Second Edition

Martin Bach, Karl Arao, Andy Colvin, Frits Hoogland, Randy Johnson, Kerry Osborne, Tanel Poder

Publisher Resources

ISBN: 1565924320Supplemental ContentCatalog PageErrata