Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> XMLQuery bug?

XMLQuery bug?

From: <sbook_at_hotbox.ru>
Date: 14 Aug 2006 00:57:24 -0700
Message-ID: <1155542244.912808.156500@m73g2000cwd.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US