In my application, currently running on Berkeley DB XML, an xquery selects all the attributes of an element, substituting one attribute by name. Here is the sample xquery:
for $el in ....
return <aaa MyAttribute="newvalue">{$el/bbb/@*[local-name()!="MyAttribute"]}</aaa>
This works in Berkeley DB XML, but doesn't in Oracle XML DB.
I get the error: SQL Error: ORA-19121: duplicate attribute definition
How can I achieve this in Oracle?
Thank you.
Bye
Mirko