DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: XMLCONCAT error

  1. #1
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72

    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

  2. #2
    Join Date
    Oct 2006
    Posts
    11

    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.

  3. #3
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72
    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
  •  


Click Here to Expand Forum to Full Width