Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

GET_ARG_TYPE Function

This function determines the type of an argument in a deferred call. The type of the deferred remote procedure call (RPC) parameter is returned.

See Also:

The Replication Management tool's online help for information about displaying deferred transactions and error transactions in the Replication Management tool

Syntax

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

Parameters

Table 13-5 GET_ARG_TYPE Function Parameters
Parameter Description
callno

Identification number from the DEFCALL view of the deferred remote procedure call.

arg_no

Numerical position of the argument to the call whose type you want to determine. The first argument to a procedure is in position 1.

deferred_tran_id

Identifier of the deferred transaction.

Exceptions

Table 13-6 GET_ARG_TYPE Function Exceptions
Exception Description
NO_DATA_FOUND

Input parameters do not correspond to a parameter of a deferred call.

Returns

Table 13-7 GET_ARG_TYPE Function Returns 
Constant Return Value Return Value Corresponding Datatype
DBMS_DEFER_QUERY.ARG_TYPE_VARCHAR2
1
VARCHAR2
DBMS_DEFER_QUERY.ARG_TYPE_NUM
2
NUMBER
DBMS_DEFER_QUERY.ARG_TYPE_ROWID
11
ROWID
DBMS_DEFER_QUERY.ARG_TYPE_DATE
12
DATE
DBMS_DEFER_QUERY.ARG_TYPE_RAW
23
RAW
DBMS_DEFER_QUERY.ARG_TYPE_CHAR
96
CHAR
DBMS_DEFER_QUERY.ARG_TYPE_AnyData
109
AnyData
DBMS_DEFER_QUERY.ARG_TYPE_CLOB
112
CLOB
DBMS_DEFER_QUERY.ARG_TYPE_BLOB
113
BLOB
DBMS_DEFER_QUERY.ARG_TYPE_BFIL
114
BFILE
DBMS_DEFER_QUERY.ARG_TYPE_OBJECT_NULL_VECTOR
121
OBJECT_NULL_VECTOR
DBMS_DEFER_QUERY.ARG_TYPE_TIMESTAMP
180
TIMESTAMP
DBMS_DEFER_QUERY.ARG_TYPE_TSTZ
181
TSTZ
DBMS_DEFER_QUERY.ARG_TYPE_IYM
182
IYM
DBMS_DEFER_QUERY.ARG_TYPE_IDS
183
IDS
DBMS_DEFER_QUERY.ARG_TYPE_TSLTZ
231
TSLTZ

Note: