Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> XMLQuery bug?
The following query:
SELECT
XMLQuery('<category>{
for $d in /categories//*[@id="CA00PE004D"]/*
let $k := ora:view("objects")/object[category/@id =
$d/descendant-or-self::category/@id]
return <category count="{count($k)}" id="{$d/@id}"
text="{$d/@title}"/>
}</category>' passing object_value returning content).getCLOBVal()
"cats"
FROM categories;
cause "ORA-19112: java.lang.OutOfMemoryError". But
SELECT
XMLQuery('<category>{
for $d in /categories//*[@id="CA00PE004D"]/*
let $k := ora:view("objects")
return <category count="{count($k)}" id="{$d/@id}"
text="{$d/@title}"/>
}</category>' passing object_value returning content).getCLOBVal()
"cats"
FROM categories;
works well.
What's wrong??
PS. java_pool_size = 500M Received on Mon Aug 14 2006 - 02:57:24 CDT