How can we convert CLOB datatype to string in OTBI Reports?
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
Tagged:
0