December 2002
Intermediate to advanced
928 pages
85h 29m
English
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.