Upload Files to Object Storage from Oracle Application Express (APEX)

It is easier to store the files uploaded through APEX within Binary large object (BLOB) in the Oracle Database. However, it increases the size of the database and considerably affecting the time to retrieve the data. On the other hand, Object Storage will enable the users to store an unlimited amount of unstructured data. The video demonstrates how easy it is to authenticate and interact with the Oracle Cloud Object Storage Service REST APIs to upload the files via APEX. This application will utilize the web credentials for authentication, REST data sources to list the buckets and their contents, store files temporarily in APEX_APPLICATION_TEMP_FILES and uses APEX_WEB_SERVICE to call the REST API to upload files to the Object Storage.

[@juliedsouza8630]

explanation given here is simple and easy to follow, a very valuable resource.

[@nachoBikeLife]

Thanks 🙏🏻 It was very helpful!

[@danielpastranah2633]

what if we just want to load a file into a shared folder in the app server?

[@QuiqueFlowers]

What is the size limit that I can upload?

[@yagnikgondaliya548744]

Thanks alot for this excellent video. I have one question. can i create folder or subfolder in bucket using this or any other method? If yes please help me.

[@marceloosorio525]

Excelent Video!!! Any chance to filter the files to avoid upload files bigger than a X size??

[@bouthikadharan4344]

where to get the URL ????

[@megavenkat1958]

created this all process but when I'm uploading file facing error - ora-01403:no data found,how to resolve this

[@TechMining69]

Enter the Web Credentials static ID as you entered while creating it. It is case-sensitive here.