Hey,
For our development cycle we use jenkins with liquibase to automatically build our plsql backend code.
We want to do the same thing for our APEX applications.
After some searching I found that I needed to set the workspace, application id and schema with the apex_application_install api. I also generated an offset.
After doing this setup (without liquibase cause all of this is not supported by liquibase) the installation of the application is without any errors.
Now I exported my supporting objects as a single file and I'm also executing this with jenking (in the end I just open an sqlplus session and execute these files).
But when I do something like this:
wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table;
wwv_flow_api.g_varchar2_table(1) := 'some code for images';
declare
l_name varchar2(255);
begin
l_name := 'uncheck.png';
wwv_flow_api.create_or_remove_file(
p_name=> l_name,
p_varchar2_table=> wwv_flow_api.g_varchar2_table,
p_mimetype=> 'image/png',
p_location=> 'APPLICATION',
p_nlang=> '0',
p_mode=> 'CREATE_OR_REPLACE',
p_type=> 'IMAGE');
end;
/
My image would not be added to the application.
When I do the exact same thing but change the p_location parameter to WORKSPACE instead of APPLICATION this code would work.
I wonder if I need to set some other stuff in the wwv_flow_api for the p_location=>'APPLICATION' to work.
It's not that it would stop our development but it's just inconvenient that we can not link images to applications anymore if we want to be able to use automatic building tools.
Any help is appreciated.
Br,
Nico