defcallinfo.sql

---------------------------------------------------------------------------
-- Filename:    defcallinfo.sql
-- Purpose:     Lists information about deferred calls.
-- Author:      Chas. Dye (cdye@excitecorp.com)
-- Date:        10-Jul-1998
---------------------------------------------------------------------------
set serveroutput on size 100000
set verify off
undef callno
undef argcnt
undef tran_db
undef tran_id

DECLARE
        vTypes  dbms_defer_query.type_ary;
        vVals   dbms_defer_query.val_ary;
        indx    NUMBER;
BEGIN
        dbms_defer_query.get_call_args(
                callno          => '&&callno',
                startarg        => 1,
                argcnt          => &&argcnt,
                argsize         => 128,
                tran_db         => '&&tran_db',
                tran_id         => '&&tran_id',
                date_fmt        => 'DD-Mon-YYYY HH24:MI:SS',
                types           => vTypes,
                vals            => vVals );

        FOR indx IN 1..&&argcnt LOOP
             dbms_output.put_line('Arg '|| indx || ' Value '|| vVals(indx));
        END LOOP;
END;
/

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial