Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Anybody resolved memory issues caused by XML for PL/SQL in 8.1.7 ?

Re: Anybody resolved memory issues caused by XML for PL/SQL in 8.1.7 ?

From: ana <anacedent_at_hotmail.com>
Date: Tue, 7 Dec 2004 12:56:54 -0800
Message-ID: <31mjo1F3d8u0kU1@individual.net>


"KurtisK" <KJKYLE_at_COOLBLUENOSPAM.COM> wrote in message news:7MKdnU-RzdnSkivcRVn-iQ_at_telcove.net...
> I don't have a recommendation outside of Oracle for parsing XML files
other
> than Java. ( outside of PL/SQL ) Jave seems the best approach. I ran
into
> problems when my XML file reached 15-20MB+. The structure of my xml
> documents varied quite a bit as they represented data from about 20
> different tables. When iterating thru this document, my PL/SQL DOM code
> didn't handle this well for whatever reason, so I had to do old fashion
text
> parsing in order to get the job done in my case. Definitely not the ideal
> approach.
>
> As for smaller XML documents, we've had good luck with Oracle XML overall.
> Our application is based on XML messaging going in and out of the database
> via PL/SQL procedures. The one case where we had to handle large XML
files
> is where it broke down.
>
> Hope this helps,
> Kurt

http://xml.coverpages.org/perl-xml-faq11.html Received on Tue Dec 07 2004 - 14:56:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US