April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- 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;
/