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 laterInformation 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 |