i'm getting the error
ORA-29554: unhandled Java out of memory condition
when trying to parse xml files into some oracle tables. my process calles several procedures and uses the oracle xml packages to parse and store data from the xml files in tables. i have been battling this issue for some time. please see theses links to find out more:
i believe i am freeing all xml components such as the processor and document. i have upped my java_max_sessionspace_size
paramter to 200mb, the java_soft_sessionsapce_lim
it to 200mb, the java_pool_size to 200mb, and used the pl/sql procedure suggested by lucy in the second link above to increase the memory for my session to 200mb. some of the files i'm parsing are fairly large, but i just can't believe i'm using up this much memory. does anybody have any idea how i can get around this? thanks.