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. |
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.