Topic
  • 1 reply
  • Latest Post - ‏2009-03-13T11:09:32Z by SystemAdmin
SystemAdmin
SystemAdmin
76 Posts

Pinned topic Problems with combined XML2CLOB, XMLAGG and XMLELEMENT function

‏2009-03-13T10:59:56Z |
Hey Guys, I'm hoping I can get a little assistance with a function here.

I am using this in a field where I just need the values returned, and I keep getting an error that a ')' is missing at the end of arguments list - but I can't for the life in me see where this error is...
replace(replace(xml2clob(xmlagg(xmlelement(NAME "a", http://Table.Field))),'',''),'',' ')
What I am using this to do is to hopefully provide me a string of the Table.Field items relating to a detail previously grouped.

Can anyone see any potential error?
Updated on 2009-03-13T11:09:32Z at 2009-03-13T11:09:32Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    76 Posts

    Re: Problems with combined XML2CLOB, XMLAGG and XMLELEMENT function

    ‏2009-03-13T11:09:32Z  
    I'm sorry it mangled my code up a bit... hopefully the real code is here...

    
    replace(replace(xml2clob(xmlagg(xmlelement(NAME 
    "a", [Table.Field]))),
    '<a>',
    ''),
    '</a>',
    ' ')