Home » SQL & PL/SQL » SQL & PL/SQL » XMLQuery bug?
XMLQuery bug? [message #187503] Mon, 14 August 2006 04:36
sbook@hotbox.ru
Messages: 1
Registered: August 2006
Location: Moscow
Junior Member
Hi All.

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
Previous Topic: error ORA-00604
Next Topic: Running Shell Scripts through Pl/Sql Procedures
Goto Forum:
  


Current Time: Sat Dec 03 01:22:40 CST 2016

Total time taken to generate the page: 0.07126 seconds