Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_DEFER_QUERY.GET_datatype_ARG

Purpose

To determine the value of an argument in a deferred call. For additional information, refer to [*].

Syntax

Depending upon the type of the argument value that you want to retrieve, the syntax for the appropriate function is as follows. The parameters for these functions are described in Table 12 - 12, and the exceptions are listed in Table 12 - 13. Each of these functions returns the value of the specified argument.

For arguments of type NUMBER:

DBMS_DEFER_QUERY.GET_NUMBER_ARG
	(callno	IN	NUMBER,
	deferred_tran_db	IN	VARCHAR2,
	arg_no	IN	NUMBER,
	deferred_tran_id	IN	VARCHAR2 DEFAULT NULL)
	RETURN NUMBER

For arguments of type VARCHAR2:

DBMS_DEFER_QUERY.GET_VARCHAR2_ARG
	(callno	IN	NUMBER,
	deferred_tran_db	IN	VARCHAR2,
	arg_no	IN	NUMBER,
	deferred_tran_id	IN	VARCHAR2 DEFAULT NULL)
	RETURN VARCHAR2

For arguments of type CHAR:

DBMS_DEFER_QUERY.GET_CHAR_ARG
	(callno	IN	NUMBER,
	deferred_tran_db	IN	VARCHAR2,
	arg_no	IN	NUMBER,
	deferred_tran_id	IN	VARCHAR2 DEFAULT NULL)
	RETURN CHAR

For arguments of type DATE:

DBMS_DEFER_QUERY.GET_DATE_ARG
	(callno	IN	NUMBER,
	deferred_tran_db	IN	VARCHAR2,
	arg_no	IN	NUMBER,
	deferred_tran_id	IN	VARCHAR2 DEFAULT NULL)
	RETURN DATE

For arguments of type RAW:

DBMS_DEFER_QUERY.GET_RAW_ARG
	(callno	IN	NUMBER,
	deferred_tran_db	IN	VARCHAR2,
	arg_no	IN	NUMBER,
	deferred_tran_id	IN	VARCHAR2 DEFAULT NULL)
	RETURN RAW

For arguments of type ROWID:

DBMS_DEFER_QUERY.GET_ROWID_ARG
	(callno	IN	NUMBER,
	deferred_tran_db	IN	VARCHAR2,
	arg_no	IN	NUMBER,
	deferred_tran_id	IN	VARCHAR2 DEFAULT NULL)
	RETURN ROWID

Parameter Description
callno The ID number from the DefCall view of the deferred remote procedure call.
deferred_tran_db Fully qualified database name that originated the transaction. This is also stored in the DefCall view.
arg_no The numerical position of the argument to the call whose value you want to determine. The first argument to a procedure is in position one.
deferred_tran_id Default NULL. The identifier of the deferred transaction. Defaults to the last transaction identifier passed to GET_ARG_TYPE.
Table 12 - 12. Parameters for GET_NUMBER/VARCHAR2/CHAR/DATE/RAW/ROWID_ARG

Exception Description
NO_DATA_FOUND The input parameters do not correspond to a parameter of a deferred call.
bad_param_type The argument in this position is not of the specified type.
Table 12 - 13. Exceptions for GET_NUMBER/VARCHAR2/CHAR/DATE/RAW/ROWID_ARG

Contents Index Home Previous Next