ORA-30951: Element or attribute at Xpath exceeds maximum length
I am getting the an error when trying to (isSchemaValid (); and schemaValidate ();0 please check code below
set serveroutput on
DECLARE
x CLOB;
v_xdoc XMLTYPE;
g_status VARCHAR2 (50);
g_msg VARCHAR2 (2000);
v_xml_ok NUMBER;
BEGIN
SELECT c --clob column from the database
INTO x
FROM test_gil
WHERE a = '1 - insert_online_xml'
AND b = 'p_message_id :FAIL201304261415231348, UNKNOWN';
set serveroutput on
DECLARE
x CLOB;
v_xdoc XMLTYPE;
g_status VARCHAR2 (50);
g_msg VARCHAR2 (2000);
v_xml_ok NUMBER;
BEGIN
SELECT c --clob column from the database
INTO x
FROM test_gil
WHERE a = '1 - insert_online_xml'
AND b = 'p_message_id :FAIL201304261415231348, UNKNOWN';
v_xdoc := xmltype (x);
-- Associate an XSD to the XML
v_xdoc := v_xdoc.createSchemaBasedXML ('NXS_CLAIM_REQ.XSD');
BEGIN
-- Validate the XML received against the XSD - 0=INVALID, 1=VALID
v_xml_ok := v_xdoc.isSchemaValid ();
0