Recent content by rdeutsch

Hi Marco For example, when adding the nvl-command i get with both Oracleversions the same "persisten field"-result -> then its always a float. select min(nvl(k.pz,0)) min_pz from myTable k group by k.lfnr But i hope that will not be the final solution. There are a lot of sql-statements which...

Hello Meanwhile we found out that the problem depends on the sql-statement: Try this sql: select min(k.pz) min_pz from myTable k group by k.lfnr Running against Oracle 12.1.0.1 results in a persistents fieldtype = float. Running against Oracle 12.2.0.1 results in a persistents fieldtype =...

Hi I use Delphi Tokio 10.2 and DOA 4.1.3.5. In our app we use persistend fields which were "imported" from a Oracle-DB (12.1.0.1) as a floatfield. Last week we migrate to Oracle Version 12.2.0.1 and now the open of the dataset crashes, because when i now import the same db-field its coming in...

Hi Marco Thanks a lot. :-) Yes that was it. On my maschine is client version 10.2.0.3 installed and our DB has version 9.2. Doc ID: Note:458010.1: "Beginning with Oracle9i, you can perform a SQL*Loader direct path load when the client and server are different versions. However, both versions...

Hi Marco Yes - i tried to include the owner but with no better result. Now we made a trace on the DB and saw that there is firing to following sql-statement: "SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.LOADER_NESTED_VARRAYS WHERE TABLE_NAME = :tname AND TABLE_OWNER = :owner". But the table...

Hi I work on BDS 2007/Delphi and Orcale 9.2.0.6.0 and DOA Version 4.1.1 When doing a Prepare on a OracleDirectPathLoader then i get always the error message: Directpath ORA-00942: Table or view not exists But the table is there. I can check this with a select-statement. When doing the same...

Hi As you surely noticed is it now possible with the new version of ODAC Net 3.0 from Core Lab to connect to oracle direct via tcp/ip - that means without the oracle client. Are you planning to do the same? If you do that, when can we expect the new update? Regards robert

When I free a form including DOA-Dataset with a large amount of data it takes more than 5 times longer than the same form using BDE. Can anyone help me?

I am writing a serviceapplication with doa. When the service is starting after a reboot of the server - how can the service detect that oracle is running.