Handling Array DML errors.

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
MarkF
Posts: 211
Joined: Thu 02 Mar 2006 14:55

Handling Array DML errors.

Post by MarkF » Wed 01 Jun 2011 13:17

Hi All,

I use Array DML and the .execute(n); call. If I send 20 records at once and record 10 has an error, I catch the error, and then I move the data in the arrays down and execute it again, repeating this process as needed. The api that I used before switching to ODAC had an overloaded .execute call that also took the array start position. This allowed re-calling the execute with the same arrays but with a different start position (avoiding all the data moving that I am currently doing.) Is there a better way for me to do this with ODAC? Alternately could an overloaded .execute( iters, startpos) be added?

Thanks for any suggestions!

-Mark Ford
Benthic Software

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

Post by AlexP » Wed 01 Jun 2011 14:57

Hello,

At the moment you will not be able to implement such functionality using our components. We will consider the possibility of adding the overloaded Execute method in one of the next versions of the product.

Post Reply