XMLCONCAT error

Hi ,
I am facing a new issue whenever i create a new database. XMLCONCAT function is not working. Its giving the following error. This function exists in sys.

select xmlconcat(xmlelement(eln,1)) from dual;

ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLCONCAT'

This is not related to wrong number or argument. Somehow i solved this in one of my instance but i dont remember how i did that.

Any help from experts?

Thanks

OS & Databade version, Please.

It works for me in 9.2.0.8:

Code:

---

SQL*Plus: Release 9.2.0.8.0 - Production on Vie Dic 1 10:45:47 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Conectado a:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

sql> select xmlconcat(xmlelement(eln,1)) from dual;

XMLCONCAT(XMLELEMENT(ELN,1))
-------------------------------------------------------------------------
[<]ELN[>]1[<]/ELN[>]

sql>

---

NOTE: the result is [<]ELN[>]1[<]/ELN[>]. I can't seem to get the tabs escaped.

HTH

Cheers.

Carlos.

Hi,
9.2.0.1 I solved this issue. Its an oracle BUG. I dropped the synonym XMLCONCAT. Now it is working fine.

Thanks,