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?
This topic has been locked.
1 reply Latest Post - 2009-03-13T11:09:32Z by SystemAdmin
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 PostsACCEPTED ANSWER
Re: Problems with combined XML2CLOB, XMLAGG and XMLELEMENT function2009-03-13T11:09:32Z in response to SystemAdminI'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>', ' ')