Oracle9i Supplied PL/SQL Packages and Types Reference Release 2 (9.2) Part Number A96612-01 |
|
DBMS_MGWMSG, 2 of 4
This type specifies a named value. The name
and type
attributes and one of the < >_value
attributes are typically nonnull.
TYPE SYS.MGW_NAME_VALUE_T IS OBJECT name VARCHAR2(250), type INTEGER, integer_value INTEGER, number_value NUMBER, text_value VARCHAR2(4000), raw_value RAW(2000), date_value DATE);
Attribute | Description |
---|---|
|
Name associated with the value |
|
Value type. Refer to the |
|
Stores a numeric integer value |
|
Stores a numeric float or large integer value |
|
Stores a |
|
Stores a |
|
Stores a date value |
Table 32-3 shows the mapping between the value type and the attribute used to store the value.
This method constructs a new MGW_NAME_VALUE_T
instance. All attributes are assigned a value of NULL.
STATIC FUNCTION CONSTRUCT RETURN SYS.MGW_NAME_VALUE_T;
These methods construct a new MGW_NAME_VALUE_T
instance initialized with the value of a specific type. Each method sets the name
and type
attributes and one of the < >_value
attributes, as shown in the mappings in Table 32-3.
STATIC FUNCTION CONSTRUCT_BOOLEAN ( name IN VARCHAR2, value IN INTEGER ) RETURN SYS.MGW_NAME_VALUE_T, STATIC FUNCTION CONSTRUCT_BYTE ( name IN VARCHAR2, value IN INTEGER ) RETURN SYS.MGW_NAME_VALUE_T, STATIC FUNCTION CONSTRUCT_SHORT ( name IN VARCHAR2, value IN INTEGER ) RETURN SYS.MGW_NAME_VALUE_T, STATIC FUNCTION CONSTRUCT_INTEGER ( name IN VARCHAR2, value IN INTEGER ) RETURN SYS.MGW_NAME_VALUE_T, STATIC FUNCTION CONSTRUCT_LONG ( name IN VARCHAR2, value IN NUMBER ) RETURN SYS.MGW_NAME_VALUE_T, STATIC FUNCTION CONSTRUCT_FLOAT ( name IN VARCHAR2, value IN NUMBER ) RETURN SYS.MGW_NAME_VALUE_T, STATIC FUNCTION CONSTRUCT_DOUBLE ( name IN VARCHAR2, value IN NUMBER ) RETURN SYS.MGW_NAME_VALUE_T, STATIC FUNCTION CONSTRUCT_TEXT ( name IN VARCHAR2, value IN VARCHAR2 ) RETURN SYS.MGW_NAME_VALUE_T, STATIC FUNCTION CONSTRUCT_RAW ( name IN VARCHAR2, value IN RAW ) RETURN SYS.MGW_NAME_VALUE_T, STATIC FUNCTION CONSTRUCT_DATE ( name IN VARCHAR2, value IN DATE ) RETURN SYS.MGW_NAME_VALUE_T );
The construct_boolean
method sets the value to either DBMS_MGWMSG.BOOLEAN_TRUE
or DBMS_MGWMSG.BOOLEAN_FALSE.
This type specifies an array of name-value pairs. An object of MGW_NAME_VALUE_ARRAY_T
type can have up to 1024 elements.
TYPE SYS.MGW_NAME_VALUE_ARRAY_T AS VARRAY (1024) OF SYS.MGW_NAME_VALUE_T;
This type specifies a TEXT
value. It can store a large value as a CLOB
or a smaller value (size <= 4000) as VARCHAR2.
Only one of the < >_ value
attributes should be set.
TYPE SYS.MGW_TEXT_VALUE_T IS OBJECT small_value VARCHAR2(4000), large_value CLOB);
Attribute | Description |
---|---|
|
Small TEXT value. Used for values <= 4000. |
|
Large TEXT value. Used when the value is too large for the |
This method constructs a new MGW_TEXT_VALUE_T
instance. All attributes are assigned a value of NULL.
STATIC FUNCTION CONSTRUCT RETURN SYS.MGW_TEXT_VALUE_T;
This type specifies a RAW value. This type can store a large value as a BLOB
or a smaller value (size <= 2000) as RAW.
Only one of the < >_value
attributes should be set.
TYPE SYS.MGW_RAW_VALUE_T IS OBJECT( small_value RAW(2000), large_value BLOB);
Attribute | Description |
---|---|
|
Small |
|
Large |
This method constructs a new MGW_RAW_VALUE_T
instance. All attributes are assigned a value of NULL.
STATIC FUNCTION CONSTRUCT RETURN SYS.MGW_RAW_VALUE_T;
This is a canonical type for a basic TEXT
or RAW
message. Only a single TEXT
or RAW
value is typically set. An object of this type should not have both TEXT
and RAW
set to a nonnull value at the same time.
TYPE SYS.MGW_BASIC_MSG_T IS OBJECT header SYS.MGW_NAME_VALUE_ARRAY_T, text_body SYS.MGW_TEXT_VALUE_T, raw_body SYS.MGW_RAW_VALUE_T);
Attribute | Description |
---|---|
|
Message header information as an array of name-value pairs |
|
Message body for a |
|
Message body for a |
This method constructs a new MGW_BASIC_MSG_T
instance. All attributes are assigned a value of NULL.
STATIC FUNCTION CONSTRUCT RETURN SYS.MGW_BASIC_MSG_T;
|
Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. |
|