How to Create a REST API to Upload a BLOB into an APEX Schema
This video will show developers how to quickly create a REST API to upload BLOB content and associated metadata into an Oracle APEX schema inside Oracle Autonomous Database. To start we will enable Oracle Rest Data Services on top of a APEX workspace schema. Next we will create the required modules, templates and handlers to build both a simple get method and a post method on our resume table. The post method will showcase how to write a custom pl/sql procedure to both read the post call parameters and wire the information to (non-blob) table columns in parallel to the binary data load of the files into the BLOB column. We will also showcase how to limit the mime types permitted on the post call to msword and pdf. The video includes a corresponding set of sample code posted in this git repo.
https://github.com/chipbaber/apex_tex...
#oracle #apex #autonomous #oci #codeinnovate #developer