5 Replies Latest reply: Aug 20, 2013 3:41 AM by Fanny__ RSS

    How to import updated version of APEX app without losing saved IR's?

    tx103108
      Oracle XE 11.2
      Apex 4.1
      Linux Red Hat 5.4
      ============

      Does anyone have suggestions on how to import updated version of APEX app without losing saved IR's?
      Also, I want to maintain app id from update to update (from revision to revision). In fact, I think that that is required in order to keep the saved IR's.

      The only process I have found that seems to "work" (i.e. loads new revision of app over old revision of app) is the following (via SQL*Plus):

      declare
      l_workspace_id number;
      begin
      select workspace_id into l_workspace_id
      from apex_workspaces
      where workspace = 'MYWORKSPACE';

      apex_application_install.set_application_id(400);
      apex_application_install.set_workspace_id(l_workspace_id);
      apex_application_install.generate_offset;
      apex_application_install.set_schema('MYSCHEMA' );
      apex_application_install.set_application_alias( 'MYSCHEMA_ALIAS' );
      end;
      /

      @new_version_of_app.sql;

      but I do not have any saved reports in this app. Will this process keep the saved IR's from the previous version of the app 'intact'?
      Thanks.

      Edited by: user601798 on Oct 11, 2012 7:02 AM