Oracle DBMS_MGWMSG
Version 23c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_MGD_ID_UTL
DBMS_MGWADM
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx