Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle APEX: Import Static workspace files using sqlplus command line

TMohammeSep 20 2021 — edited Sep 20 2021

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

This post has been answered by askMax - Maxime Tremblay on Sep 21 2021
Jump to Answer
Comments
Post Details
Added on Sep 20 2021
4 comments
1,437 views