Oracle | DBMS

Oracle DBMS_MGWMSG Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

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

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