I seem to have a problem trying to load an image to a BLOB column. I have created a directory object using CREATE OR REPLACE DIRECTORY MYDIR AS 'C:Temp'. I have also initialized the BLOB column using the EMPTY_BLOB function. Then I ran a procedure that contains the following code segment:
myfile := BFILENAME( 'MYDIR', 'PHOTO.GIF' ); DBMS_LOB.fileopen(myfile, DBMS_LOB.file_readonly); DBMS_LOB.loadfromfile( blob_col, myfile, DBMS_LOB.getlength(myfile) ); DBMS_LOB.fileclose(myfile);
When I ran the procedure, I received the following error:
ORA-22288: file or LOB operation FILEOPEN failed
The system cannot find the path specified. I tried different ways to fix the path, but I still get the same error.
Did you try defining the DIRECTORY as 'C:Temp' (using a backslash)? As long as the directory and the file are present, that should work.
Dig deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.