OTBI Analysis Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
Hello,
I'm getting the error in my OTBI Analysis: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when I add a column Called "Requirement Text" from the Sourcing - Supplier Responses Real Time subject Area.
Does anyone know if I can fix this in the OTBI Analysis SQL without having to create a new Data Model?
Thanks!
Analysis SQL:
SELECT
"- Supplier Response to Negotiation Requirements Detail"."Section Number" saw_0,
"- Supplier Response to Negotiation Requirements Detail"."Negotiation Header Negotiation Title" saw_1,
"- Supplier Response to Negotiation Requirements Detail"."Section" saw_2,
"- Supplier Response to Negotiation Requirements Detail"."Response Multiple Choice Value" saw_3,
0