Oracle Distributed Systems

Name

DBMS_DEFER_QUERY.GET_CALL_ARGS

Synopsis

The GET_CALL_ARGS procedure allows you to obtain the datatypes and values for all arguments passed to a procedure in a single call. This is the easiest way to obtain information about the datatypes and values of all passed parameters.

PROCEDURE DBMS_DEFER_QUERY.GET_CALL_ARGS
   (callno IN NUMBER,              
    startarg IN NUMBER := 1,        
    argcnt IN NUMBER,              
    argsize IN NUMBER,           
    tran_db IN VARCHAR2,          
    tran_id IN VARCHAR2,    
    date_fmt IN VARCHAR2,      
    types OUT TYPE_ARY,          
    vals OUT VAL_ARY);

There are no restrictions on calling the GET_CALL_ARGS procedure.

Parameters

Parameter Name	Description
callno	The CALLNO of the RPC as stored in the DEFCALL data dictionary view
startarg	First argument to fetch
argcnt	Number of arguments to fetch
argsize	Largest size of a returned argument
tran_db	Global name of database deferring the call (also stored in DEFCALL)
tran_id	The deferred_tran_id parameter for the call (also stored in DEFCALL)
date_fmt	Date format mask
types	Output array for argument types
vals	Output array for argument values

Exceptions

Exception Name	Number	Description
NO_DATA_FOUND	–00100	Specified argument does not exist for specified RPC.