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

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 6 Dec 2004 16:43:28 -0800
Message-ID: <1102380208.102929.23060@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. Received on Mon Dec 06 2004 - 18:43:28 CST