Last updated on JULY 14, 2017
Applies to:Oracle Application Express (formerly HTML DB) - Version 18.104.22.168.20 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Jan-2013***
***Checked for relevance on 15-Jul-2014***
When attempting to run apxldimg.sql or apex_epg_config.sql for the PL/SQL Gateway (EPG), the following error occurs when the script is attempting to load the APEX image files.
Steps to Reproduce
1. Change your working directory to the location where you have unzipped the Application Express software on the database server. This is the location of the apxldimg.sql and apex_epg_config.sql scripts.
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at "SYS.DBMS_LOB", line 523
ORA-06512: at "SYS.XMLTYPE", line 287
ORA-06512: at line 18
2. Start SQL*Plus and connect the database where Oracle Application Express is installed as SYS.
$ sqlplus sys/SYS_password as sysdba
3. Run apex_epg_config.sql:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms