Oracle9i Supplied PL/SQL Packages and Types Reference Release 2 (9.2) Part Number A96612-01 |
|
DBMS_MGWMSG, 4 of 4
This procedure appends a name-value element to the end of a name-value array.
DBMS_MGWMSG.NVARRAY_ADD ( p_array IN OUT SYS.MGW_NAME_VALUE_ARRAY_T, p_value IN SYS.MGW_NAME_VALUE_T );
This function gets the name-value element of the name you specify in p_name
from a name-value array.
DBMS_MGWMSG.NVARRAY_GET ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN SYS.MGW_NAME_VALUE_T;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The matching element, or NULL
if the specified name is not found.
This function gets the value of the name-value array element that you specify in p_name
and with the BOOLEAN_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_BOOLEAN ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN INTEGER;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function gets the value of the name-value array element that you specify in p_name
and with the BYTE_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_BYTE ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN INTEGER;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function gets the value of the name-value array element that you specify in p_name
and with the SHORT_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_SHORT ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN INTEGER;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function gets the value of the name-value array element that you specify in p_name
and with the INTEGER_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_INTEGER ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN INTEGER;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function gets the value of the name-value array element that you specify in p_name
and with the LONG_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_LONG ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN NUMBER;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function gets the value of the name-value array element that you specify in p_name
and with the FLOAT_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_FLOAT ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN NUMBER;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function gets the value of the name-value array element that you specify in p_name
and with the DOUBLE_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_DOUBLE ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN NUMBER;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function gets the value of the name-value array element that you specify in p_name
and with the TEXT_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_TEXT ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN VARCHAR2;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function gets the value of the name-value array element that you specify in p_name
and with the RAW_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_RAW ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN RAW;
Parameter | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function gets the value of the name-value array element that you specify in p_name
and with the DATE_VALUE
value type.
DBMS_MGWMSG.NVARRAY_GET_DATE ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN DATE;
Parameters | Description |
---|---|
|
The name-value array |
|
The value name |
|
Name comparison method. Values: |
The value, or NULL
if the specified name is not found or if a type mismatch exists.
This function searches a name-value array for the element with the name you specify in p_name
.
DBMS_MGWMSG.NVARRAY_FIND_NAME ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN BINARY_INTEGER;
Parameters | Description |
---|---|
|
The name-value array to search |
|
The name to find |
|
Name comparison method. Values: |
0
if the specified name is not foundThis function searches a name-value array for an element with the name and value type you specify.
DBMS_MGWMSG.NVARRAY_FIND_NAME_TYPE ( p_array IN SYS.MGW_NAME_VALUE_ARRAY_T, p_name IN VARCHAR2, p_type IN BINARY_INTEGER p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE ) RETURN BINARY_INTEGER;
Parameter | Description |
---|---|
|
The name-value array to search |
|
The name to find |
|
The value type. Refer to the value type constants in Table 32-7 . |
|
Name comparison method. Values: |
|
Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. |
|