9
DBMS_DEFER_QUERY

DBMS_DEFER_QUERY enables querying the deferred RPC queue data that is not exposed through views.

Summary of Subprograms

Table 9-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 given 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:
For more about displaying deferred transactions, see "Displaying Deferred Transactions" in the Oracle8i Replication manual. For more information about displaying error transactions, see "Displaying Error Transactions" in the Oracle8i Replication manual.

Syntax

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

Parameters

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

Return	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 RPC parameter is returned.

Syntax

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

Parameters

Table 9-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 9-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 9-7 GET_ARG_TYPE Function Returns

Return	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 given 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 9-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 9-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.

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 9-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 one.
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 9-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.

9 DBMS_DEFER_QUERY

Summary of Subprograms

Table 9-1 DBMS_DEFER_QUERY Package Subprograms

GET_ARG_FORM function

Syntax

Parameters

Table 9-2 GET_ARG_FORM Function Parameters

Exceptions

Table 9-3 GET_ARG_FORM Function Exceptions

Returns

Table 9-4 GET_ARG_Form Function Returns

GET_ARG_TYPE function

Syntax

Parameters

Table 9-5 GET_ARG_TYPE Function Parameters

Exceptions

Table 9-6 GET_ARG_TYPE Function Exceptions

Returns

Table 9-7 GET_ARG_TYPE Function Returns

GET_CALL_ARGS procedure

Syntax

Parameters

Table 9-8 GET_CALL_ARGS Procedure Parameters

Exceptions

Table 9-9 GET_CALL_ARGS Procedure Exceptions

GET_datatype_ARG function

Syntax

Parameters

Table 9-10 GET_datatype_ARG Function Parameters

Exceptions

Table 9-11 GET_datatype_ARG Function Exceptions

9
DBMS_DEFER_QUERY