DBMS_DEFER_QUERY, 2 of 2

DBMS_DEFER_QUERY Package

Summary of Subprograms

Table 10-1 DBMS_DEFER_QUERY Package Subprograms

Subprogram	Description
GET_ARG_FORM Function	Determines the form of an argument in a deferred call.
GET_ARG_TYPE Function	Determines the type of an argument in a deferred call.
GET_CALL_ARGS Procedure	Returns the text version of the various arguments for the specified call.
GET_datatype_ARG Function	Determines the value of an argument in a deferred call.

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 10-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 ID.

Exceptions

Table 10-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 10-4 GET_ARG_Form Function Returns

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

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 Manager online help for information about displaying deferred transactions and error transactions in Replication Manager.

Syntax

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

Parameters

Table 10-5 GET_ARG_TYPE Function Parameters

Parameter	Description
callno	ID 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 10-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 10-7 GET_ARG_TYPE Function Returns

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

GET_CALL_ARGS Procedure

This procedure returns the text version of the various arguments for the specified call. The text version is limited to the first 2000 bytes.

Syntax

DBMS_DEFER_QUERY.GET_CALL_ARGS (
   callno    IN  NUMBER,
   startarg  IN  NUMBER := 1,
   argcnt    IN  NUMBER,       
   argsize   IN  NUMBER,     
   tran_id   IN  VARCHAR2, 
   date_fmt  IN  VARCHAR2, 
   types     OUT TYPE_ARY,  
   forms     OUT TYPE_ARY,
   vals      OUT VAL_ARY);

Parameters

Table 10-8 GET_CALL_ARGS Procedure Parameters

Parameter	Description
callno	ID number from the `DEFCALL` view of the deferred RPC.
startarg	Numerical position of the first argument you want described.
argcnt	Number of arguments in the call.
argsize	Maximum size of returned argument.
tran_id	Identifier of the deferred transaction.
date_fmt	Format in which the date should be returned.
types	Array containing the types of arguments.
forms	Array containing the character set forms of arguments.
vals	Array containing the values of the arguments in a textual form.

Exceptions

Table 10-9 GET_CALL_ARGS Procedure Exceptions

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

GET_datatype_ARG Function

This function determines the value of an argument in a deferred call.

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

Syntax

Depending upon the type of the argument value that you want to retrieve, the syntax for the appropriate function is as follows. Each of these functions returns the value of the specified argument.

DBMS_DEFER_QUERY.GET_datatype_ARG (
   callno             IN   NUMBER,
   arg_no             IN   NUMBER,
   deferred_tran_id   IN   VARCHAR2 DEFAULT NULL)
  RETURN datatype;

where datatype:

{ NUMBER
| VARCHAR2
| CHAR
| DATE
| RAW
| ROWID
| BLOB
| CLOB
| NCLOB
| NCHAR
| NVARCHAR2 }

Parameters

Table 10-10 GET_datatype_ARG Function Parameters

Parameter	Description
callno	ID number from the `DEFCALL` view of the deferred remote procedure call.
arg_no	Numerical position of the argument to the call whose value you want to determine. The first argument to a procedure is in position 1.
deferred_tran_id	Identifier of the deferred transaction. Defaults to the last transaction identifier passed to `GET_ARG_TYPE`. The default is `NULL`.

Exceptions

Table 10-11 GET_datatype_ARG Function Exceptions

Exception	Description
NO_DATA_FOUND	Input parameters do not correspond to a parameter of a deferred call.
ORA-26564	Argument in this position is not of the specified type.