Oracle Distributed Systems

Name

DBMS_DEFER_QUERY.GET_ARG_TYPE

Synopsis

You can use this function in conjunction with GET_datatype_ARG or GET_CALL_ARGS to determine information about the deferred RPCs in the queue. GET_ARG_TYPE returns a number corresponding to the argument’s datatype.

FUNCTION DBMS_DEFER_QUEUE.GET_ARG_TYPE
   (callno IN NUMBER,
    deferred_tran_db IN VARCHAR2,
    arg_no IN  NUMBER,
    deferred_tran_id IN VARCHAR2)
RETURN NUMBER;

The following table shows the mapping ofdatatypes to return values:

Argument Datatype	GET_ARG_TYPE Return Code
BFILE (Oracle8 only)	114
BLOB (Oracle8 only)	113
CFIL (Oracle8 only)	115
CHAR	96
CLOB (Oracle8 only)	112
DATE	12
NUMBER	2
RAW	23
ROWID	11
VARCHAR2	1

Notice that the datatypes here are limited to the Oracle-supplied datatypes; you cannot, for example, defer a call to a procedure that accepts a PL/SQL table as a parameter.

There are no restrictions on calling GET_ARG_TYPE.

Parameters

Parameter Name	Description
callno	The CALLNO of the RPC, as stored in the DEFCALL data dictionary view
deferred_tran_db	Global name of the database deferring the call (also stored in DEFCALL)
arg_no	The position of the argument in the RPC
deferred_tran_id	The deferred_tran_id for the call (also stored in DEFCALL)

Exceptions

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