I checked the log file and it shows the same error as above. Kindly help me with this. Does this affect my installation or the application in any way?
Application Express Packaged and Sample Applications installation data ...Remove existing packaged applications from SGID11 workspace begin * ERROR at line 1: ORA-04067: not executed, package body "APEX_040200.WWV_FLOW_PKG_APP_INSTALL" does not exist ORA-06508: PL/SQL: could not find program unit being called: "APEX_040200.WWV_FLOW_PKG_APP_INSTALL" ORA-06512: at line 20
Though i am not sure if this is a correct solution. It worked for me, so if there are any other solution, Please do post it.
DROP USER APEX_040100 CASCADE;
ORA-28817: PL/SQL function returned an error.I got that error when I tried to access Instance Settings in http://localhost/apex/apex_admin
C:\Users\Jocelle_Admin>cd C:\apexthen run SQL
@apexins.sql SYSAUX SYSAUX TEMP /i/3-
@apxldimg.sql C:\After you deploy Apex listener and make sure everything is fine, [url http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#CBHEBDHD] Remove Prior Oracle Application Express Installations
You get something similar to:
SELECT username FROM dba_users WHERE (username LIKE 'FLOWS_%' OR USERNAME LIKE 'APEX_%') AND USERNAME NOT IN ( SELECT 'FLOWS_FILES' FROM DUAL UNION SELECT 'APEX_PUBLIC_USER' FROM DUAL UNION SELECT SCHEMA s FROM dba_registry WHERE comp_id = 'APEX');
Ok, the problem now is how to Access My Instance Settings
DROP USER APEX_040100 CASCADE; DROP USER APEX_030200 CASCADE;
when you access the Instance Settings page, please read the following thread for a solution ORA 28817 PLSQL function returned an error . when Access instance apex 4 2
ORA-28817: PL/SQL function returned an error.