This discussion is archived
5 Replies Latest reply: Aug 20, 2013 1:41 AM by Fanny__ RSS

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

tx103108 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points