Memory Leak while using XML Query
I am storing xml documents in oracle database as XMLType. My table structure would look something like this :
create table RESOURCELIST (
"ID" varchar(254) not null,
"DOCUMENT" xmltype )
xmltype column "DOCUMENT" store as binary xml;
ALTER TABLE SERVICES
ADD CONSTRAINT PK_RESOURCELIST
PRIMARY KEY ("ID");
When i try to extract specific information from within the stored xml documents using xmlquery i am seeing a substantial memory leak at the Oracle server.
My query would look something like :
select xmlquery('declare default element namespace "urn:ietf:params:xml:ns:resource-lists";for $e at $pos in $c/resource-lists/list[@name="friends"] let $result := if ($pos >= 2) then "|||||ERROR|||||" else $e return $result' passing document as "c" RETURNING CONTENT).