Oracle in a Nutshell

Calls

PROCEDURE DBMS_MGWMSG.NVARRAY_ADD (p_array IN OUT SYS.MGW_NAME_ARRAY_T, p_value IN SYS.MGS_NAME_VALUE_T);

Appends p_value to p_array.

FUNCTION DBMS_MGWMSG.NVARRAY_GET (p_array IN SYS.MGW_NAME_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE) RETURN SYS.MGW_NAME_VALUE_T;

Returns a value for p_name in p_array. p_compare is either CASE_SENSITIVE or CASE_INSENSITIVE and controls how p_name is compared to the names in p_array.

FUNCTION DBMS_MGWMSG.NVARRAY_GET_BOOLEAN (p_array IN SYS.MGW_NAME_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE) RETURN INTEGER;

Returns a value for BOOLEAN p_name in p_array. p_compare is either CASE_SENSITIVE or CASE_INSENSITIVE and controls how p_name is compared to the names in p_array.

FUNCTION DBMS_MGWMSG.NVARRAY_GET_BYTE (p_array IN SYS.MGW_NAME_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE) RETURN INTEGER;

Returns a value for BYTE p_name in p_array. p_compare is either CASE_SENSITIVE or CASE_INSENSITIVE and controls how p_name is compared to the names in p_array.

FUNCTION DBMS_MGWMSG.NVARRAY_GET_SHORT (p_array IN SYS.MGW_NAME_ARRAY_T, p_name IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE) RETURN INTEGER;

Returns a value for SHORT p_name in p_array. p_compare is either CASE_SENSITIVE or CASE_INSENSITIVE and controls how p_name is compared to the names in p_array.

FUNCTION DBMS_MGWMSG.NVARRAY_GET_INTEGER (p_array IN SYS.MGW_NAME_ARRAY_T, ...