Hi all,
I recently upgraded from 5.1 to apex 18.1
all my apps are working fine
I wanted to install some sample apps and found a way to install them all at once using following script find on Installing APEX Packaged Applications – the easy way ! | get along with Oracle and APEX
DECLARE
l_installed_app_id NUMBER;
l_workspace VARCHAR2(200) := 'PA';
BEGIN
DBMS_OUTPUT.PUT_LINE('Installing Packaged Apps in Workspace '||l_workspace);
--
APEX_UTIL.SET_WORKSPACE(l_workspace);
--
FOR cAPP IN
( SELECT PKG_APP_ID
, PKG_APP_NAME
FROM APEX_PKG_APPS
WHERE PKG_APP_TYPE = 'Database'
AND APPLICATION_ID IS NULL
AND WORKSPACE = l_workspace
ORDER BY PKG_APP_ID
)
LOOP
DBMS_OUTPUT.PUT_LINE('Install Packaged App: '||cAPP.PKG_APP_ID);
BEGIN
l_installed_app_id := APEX_PKG_APP_INSTALL.INSTALL
( p_app_id => cAPP.PKG_APP_ID
, p_authentication_type => APEX_AUTHENTICATION.C_TYPE_APEX_ACCOUNTS
, p_schema => 'PACKAGED_APPS'
);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE
( 'Installing Packaged App: '||cAPP.PKG_APP_ID||' failed!'||CHR(10)||
SQLERRM||' - '||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE
);
END;
END LOOP;
END;
it runs a long time and then gives this error :
Execution of the statement was unsuccessful. ORA-20102: Application collection WWV_FLOW_IMPORT_REMOTE_SERVERS does not exist
begin wwv_flow_api.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false)); commit; end;
Contact your application administrator. Details about this incident are available via debug id "7581".
I searched google and OTN for WWV_FLOW_IMPORT_REMOTE_SERVERS but couldn't find anything
also where can I find this :
Details about this incident are available via debug id "7581".
hope someone knows
Kr
Martin