On 31-01-14 10:41, Mats Christensen wrote:
Hi,
It seems like libzdb (probaly) won't handle CLOBs in Oracle DBs very well. When selecting a CLOB directly nothing but the value 'null' is returned, when typecasting the CLOB to ex. VARCHAR2 it works perfectly.
Mats,
Looking at the dbmail code involved I notice that the Oracle schema is the only one that defines the 'envelope' field as a CLOB. PostgreSQL and MySQL both treat it as a TEXT field. So DBMail uses ResultSet_getString to retrieve the value, not ResultSet_getBlob.
That might well explain the NULL result.
Now *why* Oracle defines that field as a CLOB, I don't know. I'm not familiar with Oracle's data-types, but if you can please use a TEXT field instead.
A cursory check of the oracle schema reveals one other instance where CLOB is used, but TEXT seems more appropriate, i.e. in the sievescripts.script field.