Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Load File From Server Into Blob Table

wowlJan 15 2021

Hi,
Is it possible to load a file from the server to a blob column on the click of a button. I can see how to get the data from a blob to the server but not the other way round.
I've thought about using an external table but the column definitions are not fixed and I wont know the definition until after the file has been loaded plus some of the columns will be greater than 4000 chars.
I will know the name of the file and file location and what i need to create (and cant) is create a button that populates the blob with the file and then other existing processes follow on from there.
I've had a look through existing questions and all I can seem to find is how to save files to the server.
Thanks in advance.

Comments
Post Details
Added on Jan 15 2021
2 comments
295 views