Using CLOB DataType in IDT/webi

[former_member402770]

Hi Experts,

How to handle CLOB data type. For Clob column....we had changed datatype of columns to varchar 4k and there were 2 rows that were > 4k in Oracle DB?...

what is the max data type that BO can accept?

Data Type of the subject field was changed from “LONGVARCHAR” to “STRING” at the Business layer. Object parses successfully.

2.Show Object Values returns an error “ORA-00932: Inconsistent datatypes: Expected – got CLOB” in webi.

Thanks,

Dinya

[former_member402770]

the values are piped values looks like dscfds|sdsdsds|dsdSDS|

I could crop it off at 4k....there are only 2 rows > than 4k of varchar type

[former_member402770]

there are no function using, it is just a very long string

[Joe_Peters]

If you're using a database function on the column and the function doesn't support CLOBs, then you'll get that error.

[former_member402770]

How to handle this CLOB type columns in Universe

Thanks,

Dinya

[Joe_Peters]

What database function are you using with the CLOB field?

[Joe_Peters]

There must be some attempted conversion going on there... What's the SQL that's generated in WebI?