How to show status of fetching one record to the client from Oracle server?

[skopovy]

I store files in Oracle BLOB field. The files are large.
From the program, written on Delphi, I select data using DOA component
TOracleDataSet.

Can I show a progress bar and display amount of bytes, received from
server and total amount of bytes during fetching one record?

I don't use threads.

 

[Marco Kalter]

You can do this by explicitly reading/writing data from/to a TLOBLocator instance. If you know the size of the data you can simply divide the data in parts that are small enough to update a progress indicator.

You can't let the dataset have control over the BLOB data though. You have to exclude the BLOB from the dataset and explicitly perform the read/write operations.