UniqueConcatenate on external Table raises ORA-00904: WM_CONCAT

[Jacobo Conrado 2]

Whenever we use the function UniqueConcatenate with a column in the Custom expression in an external Table, we are having an issue in the data base:

UniqueConcatenate([myStringVar])

 

An error occurred when executing a query in the external data source.

External error:

ORA-00904: "WM_CONCAT": invalid identifier

We already did some research:

https://oracle-base.com/articles/misc/string-aggregation-techniques

Please If someone already face this issue, help us.

Thank you so much.

Best regards.

[Khushboo Rabadia]

You can raise this idea in ideas portal to change the definition/query for oracle version above 12c for uniqueconcatenate function, as it works for oracle 11g

https://ideas.tibco.com/

This is the most effective way for you to interface directly with our product team and see the status of your enhancement ideas. For more details, please refer to https://community.spotfire.com/wiki/introduction-spotfire-idea-portal.