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?
Pinned topic Problems with combined XML2CLOB, XMLAGG and XMLELEMENT function
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-03-13T11:09:32Z at 2009-03-13T11:09:32Z by SystemAdmin
SystemAdmin 110000D4XK76 Posts
Re: Problems with combined XML2CLOB, XMLAGG and XMLELEMENT function2009-03-13T11:09:32ZThis is the accepted answer. This is the accepted answer.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>', ' ')