This content has been marked as final. Show 2 replies
When you look at an export file you see the code you posted + some more:
(where 's' is a clob containing your sort of code).
wwv_flow_api.create_install_script( p_id => 65734586813251463819 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_install_id=> 65734584003963461721 + wwv_flow_api.g_id_offset, p_name => 'AFINSRW.GIF', p_sequence=> 20, p_script_clob=> s);
So it seems you have to add a little more to your script to automate it...
It's not an export of the APEX application. It's an export of the installation script of the supporting objects.
I haven't figured out how to execute supporting objects with the APEX application script. For now I copied the installation scripts with the 'display as single script' link under supporting objects, installation scripts.
This single script is the script I'm trying to execute trough sqlplus.
I execute it this way
Everything works but when I add an image on application level with my supporting objects script then this image is not added to my APEX images.
declare lco_app_id constant apex_applications.application_id%type := 111; lco_workspace apex_applications.owner%type := 'SOME_WORKSPACE'; lco_schema apex_applications.owner%type := 'SOME_SCHEMA'; l_workspace_id apex_workspaces.workspace_id%type; begin select workspace_id into l_workspace_id from apex_workspaces where workspace = lco_workspace; apex_application_install.set_workspace_id(l_workspace_id); apex_application_install.set_application_id(lco_app_id); apex_application_install.set_schema(lco_schema); apex_application_install.generate_offset; end; / @"f111.sql"; -- My APEX application export @"f111_so.sql"; -- Supporting objects display single script commit;
When I use workspace then everything works but this means that I can not bind images to my application anymore.
Thnx for the help,