XML nodes over 64K in size cannot be inserted
Tried to read an XML document which is column(transaction_document) for table(hr_api_transactions) using XMLDOM. This
column is a CLOB Column . I have tried to collect the values in Different
Columns from this Document. But now if the Document size exceeed 64K ; code is
unable to read the Document using Program(XMLDOM).
PROCEDURE ag_xml_trig(p_document CLOB
,p_scorecard_id number)
AS
l_doc xmldom.domdocument;
l_nodelist xmldom.domnodelist;
l_nodelist1 xmldom.domnodelist;
l_nodelist2 xmldom.domnodelist;
l_nodelist3 xmldom.domnodelist;
l_nodelist4 xmldom.domnodelist;
l_nodelist5 xmldom.domnodelist;
l_node xmldom.domnode;