Replication Management API Reference, 10 of 179

GET_ARG_FORM function

This function determines the form of an argument in a deferred call. This function returns the character set ID of a deferred call parameter.

See Also:
The Replication Manager online help for information about displaying deferred transactions and error transactions in Replication Manager.

Syntax

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

Parameters

Table 8-11 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 ID.

Exceptions

Table 8-12 GET_ARG_FORM Function Exceptions

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

Returns

Table 8-13 GET_ARG_Form Function Returns

Return Value	Corresponding Datatype
1	CHAR, VARCHAR2, CLOB
2	NCHAR, NVARCHAR2, NCLOB