My Oracle Support Banner

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

Last updated on NOVEMBER 01, 2019

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.