D2010, Oracle10g and problem with VARCHAR2 and NVARCHAR2

hsk · Post by **hsk** » 07.07.2010, 20:07

Hi,

I'm using D2010 (update 4/5), Oracle 10g Express (Release 2) and ZeosLib 7.0.0-dev SVN 809.

When I tried to update a VARCHAR2 field it saves only the first character and when I tried to update a NVARCHAR2 field I got the exception "Type mismatch".

I read a topic about the exception "Type mismatch" using strings, and I tried change some code of the source, but it isn't work.

Post by **mdaems** » 29.08.2010, 23:25

hsk,
It's just this kind of trouble that made us decide not to actively support Oracle any longer. Probably D2009+ messes up the buffers used in communication with the OCI. We really need somebody who can check what really happens when posting these data in an Oracle environment. Did you find a solution?

Mark

Marius2 · Post by **Marius2** » 23.09.2010, 23:07

I just revived Zeos after 2 years, we need a component set which works with firebird, mssql and oracle (and problably some others as well in the future).

Is anybody working on the oracle OCI layer and is there any news/improvements?

I'm not afraid to look into this, but i'm totally new in the oracle area (need todo a oracle project in the next weeks)

Post by **mdaems** » 13.10.2010, 23:19

Marius2,

There have been oracle patches within the last 2 years, so please give it a try.
When you're not using D2010+ the possibility of success is even better.

Mark

Marius2 · Post by **Marius2** » 13.10.2010, 23:23

Sorry, we are using the latest 7.0 beta via svn and are using 2010 (and soon delphi XE i hope)