1 Reply Latest reply: Oct 15, 2013 8:51 PM by ittichai RSS

    Unable to install APEX packaged application to user's default schema

    user6057328

      Got 2 schemas in my workspace, AABB and APEX_DEMO. I've created a separate user, DemoAdmin with default to only APEX_DEMO, to install APEX packaged applications there.  However, when logged in as DemoAdmin, and trying to install any package, it always tries to use AABB, actually the first schema created in the workspace. Is this a bug, or is that supposedly the behavior?  Thanks for the inputs!!

        • 1. Re: Unable to install APEX packaged application to user's default schema
          ittichai

          When you tried to install a packaged application, which schema it said it will install to? The message should be displayed right before "Install Application".


          I tried to install the packaged application myself using an APEX account which has the SCHEMA2 as default. It still chose the SCHEMA1 by default. My take here is that this seems to be a limitation.

           

          Meeting Minutes
          Application Express Accounts
          WORKSPACE1
          SCHEMA1

           

          To work-around this, I install the packaged applications from the download files (fxxxx.sql) which can be found under APEX installation files (Downloads\apex_4.2.2_en\apex\core\packaged_apps). (Make sure choose the one compatible with your APEX version.) Just install it as you import an application file. During the import, you will have an option to choose which schema to import to (under Parsing Schema drop-down list).

           

          Hope it helps.

          Ittichai