eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_DEFER_QUERY dependencies on ANYDATA

Line 35: -- anydata includes instance for VARRAY, Nested Table, Object Type, REF Type

31: -----------
32: -- the following constants are added for replicated objects
33: --
34: arg_type_object_null_vector CONSTANT NUMBER := 121; -- DTYADT
35: -- anydata includes instance for VARRAY, Nested Table, Object Type, REF Type
36: -- and Opaque type.
37: arg_type_anydata CONSTANT NUMBER := 109; -- DTYINTY
38:
39: -- constants derived from SQLCS_% constants in sqldef.h

Line 37: arg_type_anydata CONSTANT NUMBER := 109; -- DTYINTY

33: --
34: arg_type_object_null_vector CONSTANT NUMBER := 121; -- DTYADT
35: -- anydata includes instance for VARRAY, Nested Table, Object Type, REF Type
36: -- and Opaque type.
37: arg_type_anydata CONSTANT NUMBER := 109; -- DTYINTY
38:
39: -- constants derived from SQLCS_% constants in sqldef.h
40: arg_csetid_none CONSTANT NUMBER := 0; -- DATE, NUMBER, ROWID, RAW, BLOB
41: -- user-defined types

Line 545: FUNCTION get_anydata_arg(callno IN NUMBER,

541: -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
542: -- queue tables.
543: -- WRONG_TYPE if the desired parameter is not an object_null_vector type
544: -------
545: FUNCTION get_anydata_arg(callno IN NUMBER,
546: arg_no IN NUMBER,
547: deferred_tran_id IN VARCHAR2 DEFAULT NULL)
548: RETURN Sys.AnyData;
549: -- Return a deferred call parameter.

Line 548: RETURN Sys.AnyData;

544: -------
545: FUNCTION get_anydata_arg(callno IN NUMBER,
546: arg_no IN NUMBER,
547: deferred_tran_id IN VARCHAR2 DEFAULT NULL)
548: RETURN Sys.AnyData;
549: -- Return a deferred call parameter.
550: -- Input parameters
551: -- callno
552: -- call identifier from the defCall view

Line 564: -- Not all types supported by get_anydata_arg can be enqueued

560: -- The value of the parameter.
561: -- Notes
562: -- Supported types include Collections, Object types, REF types and
563: -- opaque types.
564: -- Not all types supported by get_anydata_arg can be enqueued
565: -- using anydata_arg.
566: ------
567: -- EXCEPTIONS
568: -- NO_DATA_FOUND desired parameter value not found in the deferred rpc

Line 565: -- using anydata_arg.

561: -- Notes
562: -- Supported types include Collections, Object types, REF types and
563: -- opaque types.
564: -- Not all types supported by get_anydata_arg can be enqueued
565: -- using anydata_arg.
566: ------
567: -- EXCEPTIONS
568: -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
569: -- queue tables.

Line 571: -- can be handled by anydata type

567: -- EXCEPTIONS
568: -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
569: -- queue tables.
570: -- WRONG_TYPE if the desired parameter is not one of the types that
571: -- can be handled by anydata type
572: -------
573: PROCEDURE get_call_args
574: (
575: callno IN NUMBER, -- deferred call number