This sql statement causes ora 600 error
Code: Select all
SELECT XMLQUERY (
'copy $tmp := . modify
(let $n := count($tmp/root/test)
for $i in $tmp/root/test[position()=$n]/text()
return replace value of node $i with replace($i, ";", "."))
return $tmp'
PASSING XMLTYPE ('<root><test>asdasdsada;</test><test>lkjasdhalskdjhlakjsdh;</test><test>tirari;</test></root>')
RETURNING CONTENT) AS RESULT
FROM DUAL;
odac 11.0.1
compiled as 32-bit
Works using OCI but failed using direct connection
Fails also using 64-bit direct