Page 1 of 1
ORA-00600 with XMLQuery using direct connection
Posted: Tue 04 Feb 2020 15:14
by dados
Hi,
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;
delphi 10.2.3
odac 11.0.1
compiled as 32-bit
Works using OCI but failed using direct connection
Fails also using 64-bit direct
Re: ORA-00600 with XMLQuery using direct connection
Posted: Wed 05 Feb 2020 16:44
by MaximG
What is the exact version of your Oracle server? Please also specify its NLS parameters. Does the issue occur with any other version of Oracle server?
Re: ORA-00600 with XMLQuery using direct connection
Posted: Mon 17 Feb 2020 12:04
by dados
db version: 12.1.0.2.0 unix and windows and 12.1.0.1.0 unix all produce same error
Error message: ORA-00600: internal error code, arguments: [kollasg:client lob on server], [], [], [], [], [], [], [], [], [], [], []
select * from v$nls_parameters
Code: Select all
PARAMETER VALUE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-YY HH24:MI:SS
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8ISO8859P15
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
I also tried direct connection to "Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production" In Oracle Cloud and that works
Re: ORA-00600 with XMLQuery using direct connection
Posted: Fri 21 Feb 2020 16:03
by MaximG
Thank you for the information. We will investigate the described issue and let you know the results shortly.
Re: ORA-00600 with XMLQuery using direct connection
Posted: Mon 24 Feb 2020 15:48
by dados
If I make the statement return clob value with the XMLType.getClobVal() function it works. But fails when returning XMLType.
If I run with XMLType as return value withing a plsql block it's okey, but not when returning XMLType in a dataset
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)[b].getClobVal()[/b] AS RESULT
FROM DUAL;
Re: ORA-00600 with XMLQuery using direct connection
Posted: Mon 02 Mar 2020 17:10
by dados
Also tested with 11.1.2 nightly 23_02_2020 with same result.
Re: ORA-00600 with XMLQuery using direct connection
Posted: Tue 03 Mar 2020 09:32
by MaximG
Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.
Re: ORA-00600 with XMLQuery using direct connection
Posted: Wed 29 Jul 2020 15:45
by MaximG
We've reproduced and fixed the issue. The changes are available in the latest version of our product.
Re: ORA-00600 with XMLQuery using direct connection
Posted: Wed 29 Jul 2020 21:22
by dados
I've just tested it and it works like a charm. Thanks
Re: ORA-00600 with XMLQuery using direct connection
Posted: Wed 05 Aug 2020 12:37
by MaximG
We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning our product usage.