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.