Cannot Read CLOB Data From Appian

Certified Lead Developer

Hi Everyone,

I tried to setup a Clob Column within the Oracle DB by modifying the XSD as follow:

<xsd:element name="requestValue" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Column(name="REQUEST_VALUE", columnDefinition="CLOB")</xsd:appinfo>
</xsd:annotation>
</xsd:element>
I was able to write to the DB after submit an interface. However, when I tried to query from the table, I got the following error after checking the tomcat log:
ORA-00932: inconsistent datatypes: expected - got CLOB

Does anyone run into this problem before? And if so, how would you fix it?

Thank you!

  Discussion posts and replies are publicly visible