Oracle Built−in Packages- P157: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk Next query DEFCALLDEST to get the transaction ID of a the queued RPC s . You need this information to copy the transaction SQL select from defcalldest Deferred Deferred Tran Tran Call No ID DB DB Link 6631429919536 6631429919536 2 rows selected. Now use to queue this transaction to the destination named DECLARE vNodes BEGIN vNodes 1 vNodes 1 END Maintenance Procedures There are several maintenance procedures available in the DBMS_DEFER_SYS package. These procedures round out the deferred RPC repertoire by providing a means of cleaning up errors and temporarily disabling queue pushes. The procedure The DELETE_ERROR procedure allows you to delete transactions from the DEFERROR data dictionary view. The procedure also deletes the related entries from DEFCALL DEFTRAN and DEFTRANDEST. Use DELETE_ERROR if you have manually resolved a transaction that initially failed. Here is the specification PROCEDURE deferred_tran_id IN VARCHAR2 deferred_tran_db IN VARCHAR2 destination IN VARCHAR2 Parameters are summarized in the following table. Name Description deferred_tran_id ID from DEFTRAN data dictionary view of 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. There are no restrictions on calling DELETE_ERROR. Maintenance Procedures 771 Appendix A What s on the Companion Disk Exceptions
