Hi All,
I am in oracle R12.1.3, DB ( 11g, 11.2.0.3.0 64 Bit).
I am trying to read a Webservice response which send me huge amounts of Data in CDATA tags. I am using plsql programming hence i am having issues when the xml inside the CDATA goes over 32k which can happen on a dialy basis for our business model.
I found a link on metalink to parse the response if greater than 32k, I am able to download it atleast hence i have teh comeplete repsonse file with me inserted into a table as CLOB.
when i try to use extractvalue or extract(xmltype(my_response_clob), v_path, v_namespaces).getclobval() into a CLOB type variable the program fails with error message as
ORA 01706:User function result value was too large.
I tried to do a dbms_lob.substr on my_response_clob and try to see if i can chop off the part before and after CDATA and get the xml inside teh Cdata Into another clob and may be process it from there but the DBMS_LOB has a 4k limit so i am kind of stuck there.
Please suggest any ideas of how to work around this issue as soon as possible.
Somehow i am unable to paste any code here i am not sure why hence i tried to explain my problem in words. I can provide more details if needed thru email or other means if required.
Thanks,
Vijay