TOraArray problem with Delphi 32-bit VCL

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
MaximG
Devart Team
Posts: 1158
Joined: Mon 06 Jul 2015 11:34

Re: TOraArray problem with Delphi 32-bit VCL

Post by MaximG » Fri 17 Nov 2017 15:10

You are right, the mentioned fixes of the error were not included in the latest version of ODAC 10.1.3 . As a workaround, we can send you a night ODAC build including the required changes. For this, provide us with your license number and the IDE version you are interested in using the e-support form (https://www.devart.com the "Support"\"Request Support" menu)

balazs miereisz
Posts: 19
Joined: Wed 06 May 2009 14:28

Re: TOraArray problem with Delphi 32-bit VCL

Post by balazs miereisz » Wed 22 Nov 2017 15:16

Hi Team!

Thank you for the fix! The problem is almost solved! :-) Reading the data (btnReadDataClick in Delphi code example) is worked well, but writing the data (btnWriteDataClick) has the same error as before.

Best Regards,

Balázs Miereisz
WINFORM Kft.

MaximG
Devart Team
Posts: 1158
Joined: Mon 06 Jul 2015 11:34

Re: TOraArray problem with Delphi 32-bit VCL

Post by MaximG » Thu 23 Nov 2017 13:14

We are glad that the described issue with data reading is successfully solved. We will continue our investigation, understand the error causes when recording data and will let you know the results shortly.

balazs miereisz
Posts: 19
Joined: Wed 06 May 2009 14:28

Re: TOraArray problem with Delphi 32-bit VCL

Post by balazs miereisz » Tue 09 Jan 2018 12:13

Hi Team!

Do you have any update on this topic? Please treat it as a matter of urgency.

Best Regards,

Balázs Miereisz
WINFORM Kft.

balazs miereisz
Posts: 19
Joined: Wed 06 May 2009 14:28

Re: TOraArray problem with Delphi 32-bit VCL

Post by balazs miereisz » Thu 01 Feb 2018 16:28

Hi Team,

We have download and tried the latest ODAC VCL version (10.1.4 Delphi 32-bit) and this problem is still persists...

Best Regards,

Balázs Miereisz
WINFORM Kft.

MaximG
Devart Team
Posts: 1158
Joined: Mon 06 Jul 2015 11:34

Re: TOraArray problem with Delphi 32-bit VCL

Post by MaximG » Fri 16 Feb 2018 16:11

We have reproduced the problem and fixed the bug. The fix will be included in the next ODAC build. Currently, we can send you a night build of ODAC with the fix. For this, please specify your license number and the exact version of Delphi you are using via the e-support form ( https://www.devart.com the "Support"\"Request Support" menu)

balazs miereisz
Posts: 19
Joined: Wed 06 May 2009 14:28

Re: TOraArray problem with Delphi 32-bit VCL

Post by balazs miereisz » Fri 20 Apr 2018 07:39

Hi Team!

Thank you for the fix in ODAC 10.1.5 VCL! The problem is solved!

I'd like to share a little workaround to solve an Access Violation in OraObjects.pas. This AV was in ODAC VCL 9.x also. It is in the TOraArray.Clear procedure. The original code looks like this:

Code: Select all

procedure TOraArray.Clear;
begin
  CheckAlloc;

  FreeObjects;
  Check(OCI8.OCICollTrim(OCISvcCtx.hOCIEnv, OCISvcCtx.hOCIError, GetSize, Instance));
end;
We have swapped two lines and it solved the AV error:

Code: Select all

procedure TOraArray.Clear;
begin
  CheckAlloc;

  Check(OCI8.OCICollTrim(OCISvcCtx.hOCIEnv, OCISvcCtx.hOCIError, GetSize, Instance));
  FreeObjects;
end;
Please revise the code and change it if neccessary.

Best Regards,
Balázs Miereisz
WINFORM Kft.

MaximG
Devart Team
Posts: 1158
Joined: Mon 06 Jul 2015 11:34

Re: TOraArray problem with Delphi 32-bit VCL

Post by MaximG » Fri 20 Apr 2018 13:35

Thank you for the information. We will definitely consider your suggestion for making changes to the source code of our product. Perhaps you can compose and send us a small sample, in which the call of the TOraArray.Clear procedure results in Access Violation. With this sample, we will be able to thoroughly test the made changes.

Post Reply