Page 1 of 1
CLOB fields
Posted: Tue 02 Oct 2007 05:26
by chkaufmann
Hi,
with the DBX 4 driver, fields of the type CLOB are returned as ftMemo and not as ftOraClob anymore.
Before I change all my code I would like to know, if this is a mistake or if this is the default behaviour for the driver now.
cu Christian
Posted: Tue 02 Oct 2007 08:34
by Plash
ftOraClob fields cannot be used with the DBX 4 because of a bug in dbExpress. Therefore our driver creates ftMemo fields instead.
This bug is fixed in the Update Pack 3 of Delphi 2007. In the next build of DbxOda, ftOraClob fields will be created, and the next build will require the Update Pack 3.
Posted: Tue 02 Oct 2007 08:59
by chkaufmann
Plash wrote:ftOraClob fields cannot be used with the DBX 4 because of a bug in dbExpress. Therefore our driver creates ftMemo fields instead
Ok. I could live with that, but the following insert statement fails:
insert into BSGLOBAL (DATA,NAME) values (empty_clob(),:PNAME) returning DATA into :PDATA
Either with Param.DataType = ftMemo I get an error and with Param.DataType = ftOraClob the value inserted to the field contains an extra character.
Do you see any workarround for that? And when do you plan to publish a new release of your driver?
I have Upd 3 installed.
cu Christian
Posted: Tue 02 Oct 2007 10:10
by Plash
This problem occurs because the current version of our driver is not compatible with Update Pack 3.
We are planning to release the new DbxOda build in a week.