How can we convert CLOB datatype to string in OTBI Reports? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can we convert CLOB datatype to string in OTBI Reports?

edited Aug 28, 2025 12:44PM in Reporting and Analytics for HCM 1 comment

Hello,

We are trying to remove HTML tags from a CLOB datatype column in OTBI report by using Substring and Replace function in the analysis. This is resulting us to get "ORA-00932: inconsistent datatypes: expected – got CLOB" error while running the analysis in dashboard.

We understand that this error is due to applying string functions to a CLOB type column. Is there any other way to remove HTML tags in an OTBI report for a CLOB datatype attribute?

Thanks,

Vaishnavi

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!