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

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

-- 


----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com

"g3000" <carlton_gregory_at_yahoo.com> wrote in message
news:1102380208.102929.23060_at_c13g2000cwb.googlegroups.com...


> Thanks Kurt for your response.

> I was hoping I would get an email that you did but maybe it got put in

> my spam folder and deleted (filters are not all that great)

>

> Anyway, the fact that you say you are using Oracle Server 9.2.0.4 is

> not encouraging.

> Do to the fact that from my reading on Metalink and other places its

> looks like Oracle thought rewriting the XDB (DBMS_XMLDOM) in C

> underneath instead of Java would get rid of the memory issues (amoung

> others).

> Apparently this is not the case.

> I DO have the option of processing these XML files outside of the

> database.

> Do you have an option you recommend other then Java ( I say that

> because of the CM constraints I am under, I dont know if the customer

> will allow a JVM to be installed on the machine other then the one in

> the database)?

>

> The other question I have Kurt is, in your experience what size range

> is considered large with respect to encountering bugs with the XML

> parser?

>

> Thanks again for your time and code.

>