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