XML Database (MOSC)

MOSC Banner

XML nodes over 64K in size cannot be inserted

edited Jan 14, 2010 4:32AM in XML Database (MOSC) 4 commentsAnswered
Hi All,

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center