Jump to content

UniqueConcatenate on external Table raises ORA-00904: WM_CONCAT

Jacobo Conrado 2

Recommended Posts

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:



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:


Please If someone already face this issue, help us.

Thank you so much.

Best regards.

Link to comment
Share on other sites

  • 2 months later...

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


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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...