Upload BLOB and progress bar

[aparvis]

Hi

I need to store a large file in BLOB column (10MB and more). ODAC demo shows how to upload file using ParamByName('').AsOraBlob.LoadFromFile. Uploading takes time so is there a way to get upload progreaa information during this process? I'd like to show progress bar informing user how many bytes have been already uploaded.

[AlexP]

Hello,

There is no such functionality.

P.S. After loading with the LoadFromFile method, sending to the server will be a long-time operation on big data.

[opylypcz]

Hello,

does it means that there is a chance to get progress information using .LoadFromStream method ?

regards
Alex

[AlexP]

If you have a Source Edition, we can show you where to add necessary changes to solve the issue.

[opylypcz]

We are planning to buy "source edition" license, thank you.

[AlexP]

You can edit the LoadFromStream/SaveToStream method to call the event in a loop, that will display the progress percentage of file loading.