Page 1 of 1
Batch update with blobs. Is it possible?
Posted: Thu 15 Apr 2010 03:14
by gezas
Is it possible to execute TOraSQL in batch mode when it has blob type parameter?
Posted: Thu 15 Apr 2010 08:18
by bork
Please describe what batch mode means. Is it using of DML array parameters or something else?
Posted: Thu 15 Apr 2010 23:20
by gezas
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
Posted: Fri 16 Apr 2010 12:50
by bork
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.
Posted: Sun 18 Apr 2010 20:21
by gezas
Hi Bork,
thanks for the info. It would be really helpful to overcome performance issues with our application.
Cheers
Geza
follow up
Posted: Tue 28 Dec 2010 21:49
by gezas
Hi,
any update on this, please?
Cheers
Geza
Posted: Wed 29 Dec 2010 12:07
by AlexP
Hello,
We are looking for a solution for this problem
We will notify you as soon as we have any results.
Re: Batch update with blobs. Is it possible?
Posted: Mon 29 Dec 2014 07:38
by gezas
Hi,
any update on this, please?
Cheers
Geza
Re: Batch update with blobs. Is it possible?
Posted: Tue 30 Dec 2014 08:22
by AlexP
No, this feature is not yet implemented.