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
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
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx