-
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
-
Vesion?
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.
Last edited by CarlosAL; 12-01-2006 at 06:10 AM.
-
Hi,
9.2.0.1 I solved this issue. Its an oracle BUG. I dropped the synonym XMLCONCAT. Now it is working fine.
Thanks,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|