Hi APEX folks,
We use APEX static workspace files extensively in our applications.
We use source control system to store application exports (.sql) files along with static workspace files (app1.js, app2.js etc.)
All application exports are .sql files and can be exported and imported to different workspaces directly from command line.
Is there a similar way of importing static workspace files using SQLPLUS command line?
The below are the approaches I tried, but each with one drawback.
Approach 1: Create one SQL file with insert scripts for each individual file into wwv_flow_company_static_files by converting the content into blob. But we cannot have version control with this approach (or will have to maintain both file as well as blob versions)
Approach 2: Can't use utl_file or dbms_lob as they require the files to be present on the DB server.
Thanks in advance