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_FORM Function

This function returns the character set form of a deferred call parameter.

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_FORM (
   callno                IN   NUMBER,
   arg_no                IN   NUMBER,
   deferred_tran_id      IN   VARCHAR2)
  RETURN NUMBER;

Parameters

Table 13-2 GET_ARG_FORM Function Parameters
Parameter Description
callno

Call identifier from the DEFCALL view.

arg_no

Position of desired parameter in calls argument list. Parameter positions are 1...number of parameters in call.

deferred_tran_id

Deferred transaction identification.

Exceptions

Table 13-3 GET_ARG_FORM Function Exceptions
Exception Description
NO_DATA_FOUND

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

Returns

Table 13-4 GET_ARG_FORM Function Returns
Constant Return Value Return Value Possible Datatype
DBMS_DEFER_QUERY.ARG_FORM_NONE
0
DATE
NUMBER
ROWID
RAW
BLOB
User-defined types
DBMS_DEFER_QUERY.ARG_FORM_IMPLICIT
1
CHAR
VARCHAR2
CLOB
DBMS_DEFER_QUERY.ARG_FORM_NCHAR
2
NCHAR
NVARCHAR2
NCLOB