This content has been marked as final. Show 3 replies
are you sure APEX_INSTALLATION was a synonym of us? Because I couldn't find any reference to that in our code. The package we use in our export/import scripts is wwv_flow_application_install/apex_application_install.
Which other synonyms are missing. And how does such an APEX_INSTALLATION call look like?
My Blog: http://www.inside-oracle-apex.com
APEX Plug-Ins: http://apex.oracle.com/plugins
sorry, I've been mislead in regard to the synonym name we're missing. Actually, in our installation, many synonyms are missing, including APEX_APPLICATION_INSTALL. Our scripts moan about this, as they can't resolve this package name. Here's a list of the synonyms that were created during installation. As you can see, all APEX_* and HTMLDB_* synonyms are missing:
So as a result of this, even if we export an application from the 4.2-IDE, we can't get it to install properly using SQL*Plus. When installing the exported application using the IDE, everything works fine though.
Can you advice us on how to check the installation script? Should there be a script file that installs the synonyms? We were searching for it, but had no luck finding it.
just to conclude this open discussion: We were able to fix the problem.
Reason was that we were running a script along with the installation that adjusted Workspace-ID etc. according to our requirements. This script calle apex_application_install in the following form:
Due to a change in the creation of the synonyms (they now belong to PUBLIC and not to APEX_040100 anymore), this then caused the error we encountered. After fixing this, anything works fine.