Recent content by Ruudbern

Hi Marco, not the answer i was hoping for. This would be a major investment in multiple components and a lot of work. No workaround? Is this the only issue with 21c or is there more that you know of? Can you give some insight of the root/cause of this problem? Do you know of a setting in...

Hi Marco, It's Oracle database 21c Enterprise Edition Release 21.0.0.0.0.- Product version 21.3.0.0.0 Thanks in advance for looking in to this, kind regards Ruud

Hi, We are using Delphi XE2 and DOA 4.1.3.1 and are facing error: "A query with LOB's requires OCI8 mode, but OCI7 mode is used". Is there a fix for this version available? I read on the forum that it is fixed in 4.1.4 but i don't see a download for XE2 for that version. Kind regards Ruud

Customer confirmed correct working of plsql

Hi Marco, i will ask them to verify correct working of sqlplus.exe. But i know an other delhi/direct oracle access service running in the same use account works correctly .kind regards Ruud

Hi Marco. i tried to make an interactive session but that application crashes immediately but mentions an other dll: Problem signature: Problem Event Name: APPCRASH Application Name: Tester.exe Application Version...

Hi, after moving to an new oracle19 machine one of our customers gets an Access violation at address 7364A074 in module 'oranls19.dll'. read of address 00000004. We are using delphi xe2 and Direct Oracle Access 4.1.3.1 in an windows service. At startup we test connecting to oracle, connecting...

Hi Marco, thanks for your reply. It turned out to be a wacky instant client installation. Installilng the full client seems to have fixed the problem. kind regards Ruud

Hi I am stumbling upon this oracle error: ORA-24812: character set conversion to or from UCS2 failed. When running the program normaly it works ok. When starting the program on the same machine connecting to the same database from a windowsservice it is generating this ORA-24812 error. The...

Thanks for your quick response

Could Session.Preferences.MaxStringFieldSize help me here? Ruud

Hi, do the direct oracle access components support the oracle 12c extended strings? Varchar2 longer than 4000; One of our customers changed max_string_size to EXTENDED and almost immediately runs into access violations. thanks in advance Ruud

Hi Marco, Thanks for the super fast reply. It seems that multiplying the field by 1 in the where clause does the trick. In the given example test1 changes to integer again: SELECT test1, test2, COUNT(*) As Quantity FROM Testtable WHERE test1*1 = 1 GROUP BY test1, test2 i will...

Still no other way to tackle this? We have a database with over 1000 of type number(1) fields. It will take weeks for us to check all queries in our application.

Hi Marco, I know that parameters are being cleared and filled again by the parameter value from the clientdataset. Is it possible to stop this clearing by the clientdataset? Hide them for the clientdataset. kind regards Ruud