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