XML Database (MOSC)

MOSC Banner

Memory Leak while using XML Query

edited Feb 1, 2010 9:22AM in XML Database (MOSC) 1 commentAnswered
 Hello

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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center