Zeoslib Portal

I've recently moved from 7.0.3 to 7.1.1-rc and found missing UTF8StringsAsWideField property in TZConnection component. Since then i've problems with retriving fields containing national chars.

whether it was a deliberate action or this property has been moved somewhere else ?

Sorry for drilling this issue to the limit, but HotFix did not solved problem - there was no problem on Delphi side, but with the oracle client. I have used 10.2.0.3 client, and after putting instant client 10.2.0.4 into my application - it started to work. After more digging I found, that problem w...

@toyman Latest version of Delphi XE2 was Update 4 Hotfix 1. http://edn.embarcadero.com/article/42282 That you use? I had no problems with it and Oracle Database Express Edition 11g Release 2. Michal At last. After installing Update 4 hitfix 1 everyting backed to normal. Thans for advice. Problem so...

I have only: Delphi XE2 and C++Builder XE2 Update 4 - in the Installed Updates section of About window.

Thanks for information. I'll try install hotfix 1 and we will see if it solve problem.

In my case TeamViever session is not an option - I work with Oracle database via VPN, which is configurad to disable any other communication - including LAN. I cannot disable this option - this is configured by other side. But - You say if I let You look at my environment via TV - You can spend some...

I have't any problems with ZEOS and Oracle BEFORE installation Update 4 for Delphi XE2.

Question: Do You have update 4 installed in Your XE2 environment ?

No. I'm not using TCurrencyFields. Today I have moved to 7.1.1-rc (TZConnection.Version property says: 7.0.3-beta - I was unable to find 7.0.6 on sourceforge) and ... nothing changed. Still got OCI_ERROR As I say - ZEOS 6.6.5-stable works on the same environment (on Delphi 7. The same machine where ...

Thank You for Your time - did't expect any reaction ;) I have commented old version of ZLoadLibrary function, and inserted Your version. After rebuilding - Error message did not disappeard and did not changed - it still says: "SQL Error: OCI_ERROR: " After debugging ZLoadLibrary variables ...

I have used wrong description. Instead of Of course - I have put valid path+file name into LibraryPath I should say Of course - I have put valid path+file name into LibraryLocation property in the ZConnection component My target platform is Win32, and oracle client is also 32bit. I have tested this ...

After updateing my XE2 to Update 4 I no longer can connect with Oracle databases of my client. Anytime I try to connect, I have got error message: None of the dynamic libraries can be found or is not loadable: oci.dll ! Use TZConnection.LibraryLocation if the location is invalid Of course - I have p...

I found a solution. Something close enough to my expectations. Solution is simple - make partial reads until result set is empty. Delphi code looks like this: procedure ExecSQL(ASQL: string); var l_limit,l_offset : Integer; begin l_offset:=0; l_limit:=10000; repeat Query.SQL.Clear; Query.SQL.Add('('...

Thanks all for advices.

I know that problem is bit complicated - otherwise I will not bother You.

Maby I didn't explain clear enough My program migration package between (actually) 4 (four) dabase systems (all on different Databaes - Oracle, PostgreSQL, MySQL, DB2). Yes - all 100 columns should be included in dataset - this is caused by input format one of the supported system - it imports data ...

fetching data from pg_class will not work, because I use a lot of joins, unions, and so on in one query (there is 25 different complicated queries collecting data from many tables). By 'slow' I mean doubling time needed for counting and then extracting data - Postgres need at the beginning to prepar...

I'm developing application for data migration between serval systems. During test I experienced problem with "Out of memory" while fetching big result (about 360 000 records in about 100 columns). Application exports data from database into CSV file (after some processing). I thought about...