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