Oracle in a Nutshell

DBMS_DEFER_QUERY

Allows you to query the deferred transactions queue data that is not exposed through normal data dictionary views.

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

Returns the character set form of the deferred call parameter.

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

Determines the type of an argument in a deferred call.

PROCEDURE 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_ANY, forms OUT TYPE_ANY, vals OUT VAL_ANY);

Returns the text version of the arguments of callno.

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

Determines the value of an argument in callno.

FUNCTION DBMS_DEFER_QUERY.GET_OBJECT_NULL_VECTOR_ARG (callno IN NUMBER, arg_no IN NUMBER, deferred_tran_id IN VARCHAR2) RETURN SYSTEM.REPCAT$_OBJECT_NULL_VECTOR;

Returns type information for a column object. New with Oracle9i.