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

Thread: XMLCONCAT error

Threaded View

  1. #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.

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