Batch update with blobs. Is it possible?

gezas · Post by **gezas** » Thu 15 Apr 2010 03:14

Is it possible to execute TOraSQL in batch mode when it has blob type parameter?

bork · Post by **bork** » Thu 15 Apr 2010 08:18

Please describe what batch mode means. Is it using of DML array parameters or something else?

gezas · Post by **gezas** » Thu 15 Apr 2010 23:20

Hi Bork,

Thank you for the quick response.

I am using TOraSQL to execute INSERT and UPDATE statements.

I use the TOraParam.ItemAsInteger[]… properties to populate the query parameters for multiple rows.

Then I use the TOraSQL.Execute(aRowCount) method to run the sql command.

The issue I run into is that I did not found for TOraParam.AsBlob a TOraParam.ItemAsBlob[] equivalent.

Cheers
Geza

bork · Post by **bork** » Fri 16 Apr 2010 12:50

Hello

Unfortunately DAC components can not define parameter as an array of Blob values. We will investigate the possibility of adding this feature in one of the next builds/versions of ODAC.

gezas · Post by **gezas** » Sun 18 Apr 2010 20:21

Hi Bork,

thanks for the info. It would be really helpful to overcome performance issues with our application.

Cheers

Geza

gezas · Post by **gezas** » Tue 28 Dec 2010 21:49

Hi,

any update on this, please?

Cheers
Geza

AlexP · Post by **AlexP** » Wed 29 Dec 2010 12:07

Hello,

We are looking for a solution for this problem
We will notify you as soon as we have any results.

gezas · Post by **gezas** » Mon 29 Dec 2014 07:38

Hi,

any update on this, please?
Cheers
Geza

AlexP · Post by **AlexP** » Tue 30 Dec 2014 08:22

No, this feature is not yet implemented.

Devart Forums

Batch update with blobs. Is it possible?

Batch update with blobs. Is it possible?

follow up

Re: Batch update with blobs. Is it possible?

Re: Batch update with blobs. Is it possible?