Oracle | DBMS

Oracle DBMS_MGWMSG Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose A public helper package for working with MGW canonical message types. It contains constant definitions, utility procedures, and other utilities.

AUTHID DEFINER

Constants

Name	Data Type	Value
Value Types
TEXT_VALUE	BINARY_INTEGER	1
RAW_VALUE	BINARY_INTEGER	2
BOOLEAN_VALUE	BINARY_INTEGER	3
BYTE_VALUE	BINARY_INTEGER	4
SHORT_VALUE	BINARY_INTEGER	5
INTEGER_VALUE	BINARY_INTEGER	6
LONG_VALUE	BINARY_INTEGER	7
FLOAT_VALUE	BINARY_INTEGER	8
DOUBLE_VALUE	BINARY_INTEGER	9
DATE_VALUE	BINARY_INTEGER	10
BOOLEAN Value Types
BOOLEAN_FALSE	BINARY_INTEGER	0
BOOLEAN_TRUE	BINARY_INTEGER	1
String Comparision
CASE_SENSITIVE	BINARY_INTEGER	0
CASE_INSENSITIVE	BINARY_INTEGER	1
TIB/Rendezvous Field Types
TIBRVMSG_UNKNOWN	BINARY_INTEGER	0
TIBRVMSG_BOOL	BINARY_INTEGER	1
TIBRVMSG_F32	BINARY_INTEGER	2
TIBRVMSG_F64	BINARY_INTEGER	3
TIBRVMSG_I8	BINARY_INTEGER	4
TIBRVMSG_I16	BINARY_INTEGER	5
TIBRVMSG_I32	BINARY_INTEGER	6
TIBRVMSG_I64	BINARY_INTEGER	7
TIBRVMSG_IPADDR32	BINARY_INTEGER	8
TIBRVMSG_IPPORT16	BINARY_INTEGER	9
TIBRVMSG_DATETIME	BINARY_INTEGER	10
TIBRVMSG_F32ARRAY	BINARY_INTEGER	11
TIBRVMSG_F64ARRAY	BINARY_INTEGER	12
TIBRVMSG_I8ARRAY	BINARY_INTEGER	13
TIBRVMSG_I16ARRAY	BINARY_INTEGER	14
TIBRVMSG_I32ARRAY	BINARY_INTEGER	15
TIBRVMSG_I64ARRAY	BINARY_INTEGER	16
TIBRVMSG_OPAQUE	BINARY_INTEGER	17
TIBRVMSG_STRING	BINARY_INTEGER	18
TIBRVMSG_XML	BINARY_INTEGER	19
Java Numeric Ranges - 8 bit
JAVA_BYTE_MINVAL	INTEGER	-128
JAVA_BYTE_MAXVAL	INTEGER	127
Java Numeric Ranges - 16 bit
JAVA_SHORT_MINVAL	INTEGER	-32768
JAVA_SHORT_MAXVAL	INTEGER	32767
Java Numeric Ranges - 32 bit
JAVA_INT_MINVAL	INTEGER	-2147483648
JAVA_INT_MAXVAL	INTEGER	2147483647

Dependencies

ANYDATA	MGW_NAME_VALUE_ARRAY_T	MGW_TIBRV_MSG_T
DBMS_STREAMS_LCR_INT	MGW_NAME_VALUE_T	PLITBLM
DBMS_SYS_ERROR	MGW_NUMBER_ARRAY_T	XMLTYPE

Documented Yes: Packages and Types ReferencePackages and Types Documentation

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/mgw/admin/mgwmsg.sql
{ORACLE_HOME}/mgw/admin/mgwmsgb.plb

Install from $ORACLE_HOME/mgw/admin/catmgw.sql

Subprograms

CHECK_RANGE	NVARRAY_GET	NVARRAY_GET_INTEGER
IS_SAME	NVARRAY_GET_BOOLEAN	NVARRAY_GET_LONG
LCR_TO_XML	NVARRAY_GET_BYTE	NVARRAY_GET_RAW
NVARRAY_ADD	NVARRAY_GET_DATE	NVARRAY_GET_SHORT
NVARRAY_FIND_NAME	NVARRAY_GET_DOUBLE	NVARRAY_GET_TEXT
NVARRAY_FIND_NAME_TYPE	NVARRAY_GET_FLOAT	XML_TO_LCR

CHECK_RANGE

Undocumented

Overload 1 dbms_mgwmsg.check_range( p_value IN INTEGER, p_minval IN INTEGER, p_maxval IN INTEGER, p_errm_value IN VARCHAR2);

TBD

Overload 2 dbms_mgwmsg.check_range( p_numarray IN sys.mgw_number_array_t, p_minval IN INTEGER, p_maxval IN INTEGER, p_errm_value IN VARCHAR2);

TBD

IS_SAME

Performs case sensitive and case insensitive string comparisons dbms_mgwmsg.is_same( p_str1 IN VARCHAR2, p_str2 IN VARCHAR2, p_compare IN BINARY_INTEGER DEFAULT CASE_SENSITIVE) RETURN BOOLEAN;

BEGIN

        IF dbms_mgwmsg.is_same('Morgan', 'Morgan', dbms_mgwmsg.case_sensitive) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      

        IF dbms_mgwmsg.is_same('Morgan', 'MoRGan', dbms_mgwmsg.case_insensitive) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

      T

      

      PL/SQL procedure successfully completed.

LCR_TO_XML

Undocumented dbms_mgwmsg.lcr_to_xml(p_anydata IN sys.anydata) RETURN sys.xmltype;

TBD

NVARRAY_ADD

Undocumented dbms_mgwmsg.nvarray_add( p_array IN OUT sys.mgw_name_value_array_t, p_value IN sys.mgw_name_value_t);

TBD

NVARRAY_FIND_NAME

Undocumented 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;

TBD

NVARRAY_FIND_NAME_TYPE

Undocumented dbms_mgwmsg.nvarray_fine_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;

TBD

NVARRAY_GET

Undocumented 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;

TBD

NVARRAY_GET_BOOLEAN

Undocumented 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;

TBD

NVARRAY_GET_BYTE

Undocumented 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;

TBD

NVARRAY_GET_DATE

Undocumented 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;

TBD

NVARRAY_GET_DOUBLE

Undocumented 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;

TBD

NVARRAY_GET_FLOAT

Undocumented 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;

TBD

NVARRAY_GET_INTEGER

Undocumented 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;

TBD

NVARRAY_GET_LONG

Undocumented 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;

TBD

NVARRAY_GET_RAW

Undocumented 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;

TBD

NVARRAY_GET_SHORT

Undocumented 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;

TBD

NVARRAY_GET_TEXT

Undocumented 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;

TBD

XML_TO_LCR

Undocumented dbms_mgwmsg.xml_to_lcr(p_xmldata IN sys.xmltype) RETURN sys.anydata;

TBD