problem in TDAScript.Execute

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Iliev
Posts: 7
Joined: Fri 18 Dec 2009 12:06

problem in TDAScript.Execute

Post by Iliev » Mon 11 Jun 2012 07:32

Hi,

My problem happened when I try to execute sql script via OraAcript, then break execution (or script raises an exception) and after that try to execute same script again (without restarting application or recreating OraScript).

I start finding a solution for my problem and I found that TDAScript.Execute doesn't initialize FProcessor.FCurrentStatementIdx and this causes my problem.

I think the same problem will happen when you try to change sql script and execute it again without recreating OraScript.

So I've just initialized index in TDAScript.Execute like this:

Code: Select all

...
  FProcessor.FCurrentStatementIdx := -1; // <--------- My Fix
  FProcessor.FCurrDelimiter := FDelimiter;
...
P.S. I'm using ODAC 8.1.5 with Delphi XE

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: problem in TDAScript.Execute

Post by AlexP » Mon 11 Jun 2012 11:52

hello,

Thank you for the information. We have reproduced the problem, and will try to include this fix to the next version.

Post Reply