Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER_QUERY.GET_ARG_TYPE

Purpose

To determine the type of an argument in a deferred call. For additional information, refer to

Syntax

The parameters for the GET_ARG_TYPE function are described in Table 12 - 9, the exception is listed in Table 12 - 10, and the possible return values are described in Table 12 - 11. The syntax for this procedure is shown below:

DBMS_DEFER_QUERY.GET_ARG_TYPE(
		callno	IN	NUMBER,
		deferred_tran_db	IN	VARCHAR2,
		arg_no	IN	NUMBER,
		deferred_tran_id	IN	VARCHAR2)
	RETURN NUMBER

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 type you want to determine. The first argument to a procedure is in position one.
deferred_tran_id The identifier of the deferred transaction.

Table 12 - 9. Parameters for GET_ARG_TYPE

Exception Description
NO_DATA_FOUND The input parameters do not correspond to a parameter of a deferred call.

Table 12 - 10. Exception for GET_ARG_TYPE

Return Value Corresponding Datatype
1 VARCHAR2
2 NUMBER
11 ROWID
12 DATE
23 RAW
96 CHAR

Table 12 - 11. Return Values for GET_ARG_TYPE

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 type you want to determine. The first argument to a procedure is in position one.
`deferred_tran_id`	The identifier of the deferred transaction.

Exception	Description
NO_DATA_FOUND	The input parameters do not correspond to a parameter of a deferred call.

Return Value	Corresponding Datatype
1	VARCHAR2
2	NUMBER
11	ROWID
12	DATE
23	RAW
96	CHAR