April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- Filename: gendelerrtran.sql
-- Purpose: Generates calls to dbms_defer_sys to delete transactions
-- that have resulted in errors for a particular table.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 27-May-1998
---------------------------------------------------------------------------
SELECT 'EXECUTE dbms_defer_sys.delete_error(' || chr(39) ||
deferred_tran_id || chr(39) || ', '|| chr(39) ||
destination || chr(39) || ' );', 'COMMIT;'
FROM deferror e
WHERE EXISTS (
SELECT deferred_tran_id
FROM defcall c
WHERE c.deferred_tran_id = e.deferred_tran_id
AND c.packagename like upper('%&target_table%'))
/