Unifier (MOSC)

MOSC Banner

How to include a CLOB field in UDR creation?

in Unifier (MOSC) 1 commentAnswered

In the unifier_sys_workflow_template table, there's a CLOB field named SETUP that contains XML-formatted data. While the field is visible in the Data View, its content isn't rendered due to the CLOB/XML format.

However, when attempting to create a UDR, the SETUP field does not appear in the list of available columns. Since we need to read and analyze the XML content within this field, UDR creation is essential — but currently not feasible because the field is missing from the UDR configuration options and we previously used UDRs for this purpose. However, after upgrading to version 25.5, we are unable to retrieve CLOB data in UDRs as we did before.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center