-
Problem with XMLQuery
Hi All.
The following query:
SELECT
XMLQuery('{
for $d in /categories//*[@id="CA00PE004D"]/*
let $k := ora:view("objects")/object[category/@id =
$d/descendant-or-self::category/@id]
return
text="{$d/@title}"/>
}' passing object_value returning content).getCLOBVal()
"cats"
FROM categories;
cause "ORA-19112: java.lang.OutOfMemoryError". But
SELECT
XMLQuery('{
for $d in /categories//*[@id="CA00PE004D"]/*
let $k := ora:view("objects")
return
text="{$d/@title}"/>
}' passing object_value returning content).getCLOBVal()
"cats"
FROM categories;
works well.
What's wrong??
PS. java_pool_size = 500M