Oracle Distributed Systems

DBMS_DEFER_QUERY: Performing Diagnostics and Maintenance

Occasionally, you may want to see details about deferred RPCs in the queue, such as what procedure and parameters are used. The DBMS_DEFER_QUERY package contains procedures to display this data.

How the Package Is Used

Typically, this package is used to assist in debugging errors and conflicts that have occurred during the execution of an RPC.

Installation and Access

The DBMS_REPCAT_QUERY package is created when the Oracle database is installed. The dbmsdefr.sqlscript (found in the built-in packages source directory) contains the source code for this package’s specification. This script is called by catrep.sql, which must be run to install the advanced replication packages. The wrapped SQL script prvtrctf.sqlcreates the public synonym DBMS_REPCAT_QUERY. No EXECUTE privileges are granted on DBMS_REPCAT_QUERY; only the owner (SYS) and those with the EXECUTE ANY PROCEDURE system privilege may execute the package.

There are no exceptions defined for this package.

DBMS_DEFER_QUERY Procedures

Procedure Name	Description
GET_ARG_TYPE	Returns the type of a parameter in a deferred call
GET_CALL_ARGS	Returns information about parameters in text form
GET_datatype_ARG	Returns the value of a parameter whose type is datatype ; values can be CHAR, DATE, NUMBER, RAW, ROWID, or VARCHAR2

DBMS_DEFER_QUERY Nonprogram Elements

Type and Name	Description
TYPE type_ary	Table of NUMBER
TYPE val_ary	Table of VARCHAR2(2000)

The PL/SQL tables type_ary and val_ary are ...