ORA-22288 File or LOB Operation FILEOPEN Failed Loading Image On ORDImage Using importFrom Method (Doc ID 736622.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Multimedia - Version 10.1.0.2 and later
Information in this document applies to any platform.


Symptoms

Trying to load an image to an ORDImage object using importFrom method we receive error:

declare
img ordsys.ordimage;
ctx raw(4000) := null;
begin
select image into img from images where id=1 for update;
img.importFrom(ctx, 'file', 'IMAGEDIR', 'earth.jpg');
update images set image=img where id=1;
end;
/


*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
Permission denied
ORA-06512: at "SYS.DBMS_LOB", line 635
ORA-06512: at "ORDPLUGINS.ORDX_FILE_SOURCE", line 140
ORA-06512: at "ORDSYS.ORDSOURCE", line 262
ORA-06512: at "ORDSYS.ORDIMG_PKG", line 1035
ORA-06512: at "ORDSYS.ORDIMAGE", line 591
ORA-06512: at line 6

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms