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