Oracle Distributed Systems

Name

DBMS_DEFER_QUERY.GET_datatype_ARG

Synopsis

The GET_datatype_ARG function returns a value of a certain type (specified by datatype). The type of the returned value corresponds to the value of the argument specified by arg_no in the deferred RPC corresponding to callno.

There is one variant of the GET_datatype_ARG function for each of the Oracle-supplied datatypes.

FUNCTION DBMS_DEFER_QUERY.GET_datatype_ARG
   (callno IN NUMBER,                   
   deferred_tran_db IN VARCHAR2
   arg_no IN NUMBER,
   deferred_tran_id IN VARCHAR2 DEFAULT NULL)
RETURN arg;

datatype can be any type in the following table.

Oracle7 and Oracle8	Oracle8 Only
CHAR	NCHAR
DATE	NVARCHAR2
NUMBER	BLOB
RAW	CLOB
ROWID	NCLOB
VARCHAR2

Therefore, any of the following are valid:

FUNCTION DBMS_DEFER_QUERY.GET_CHAR_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_DATE_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_NUMBER_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_RAW_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_ROWID_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_VARCHAR2_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_NCHAR_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_NVARCHAR2_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_BLOB_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_CLOB_ARG...
FUNCTION DBMS_DEFER_QUERY.GET_NCLOB_ARG...

Parameters have the same meanings described for the GET_ARG_TYPE procedure.

Exceptions

Exception Name	Number	Description
NO_DATA_FOUND	–00100	Specified argument does not exist for specified RPC.
WRONG_TYPE	–26564	Specified argument is not of type datatype.