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!

Importing APEX app with PL/SQL does not change app id as requested

tx103108Aug 26 2013 — edited Nov 7 2013

Oracle DB XE 11gR1

APEX 4.2.2

RHEL 6.3

------------------

The following code segment does successfully import an APEX app that has been exported.  However, even when given a 'new' application id, the 'old' application id from within the export is still used.

What could be wrong? That is, how can I ensure that the 'new' application id is used and overrides the 'old' application id that comes with the APEX app export file?

declare                 .....

                  wwv_flow_api.set_security_group_id(p_security_group_id => v_secgrp_id);
                  apex_application_install.set_application_id(t_new_app);  # does not change app id to new app id
                  ....
                 
                  exception
                  when others
                  .....
                end;
/

@APEX_export.sql;

commit;

Thanks.

This post has been answered by tx103108 on Nov 7 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2013
Added on Aug 26 2013
11 comments
1,804 views