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:
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.
This was first published in March 2004