chalie001
asked on
ORA-22285: non-existent directory or file for FILEOPEN operation
hi am geting the following error
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 805
ORA-06512: at "Iusername.LOAD_IMAGES", line 17
ORA-06512: at line 1
am using this script
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 805
ORA-06512: at "Iusername.LOAD_IMAGES", line 17
ORA-06512: at line 1
am using this script
create or replace procedure load_images
(
p_id in number,
p_file_name in varchar2
)
is
v_bfile bfile := bfilename( 'IMAGES' , p_file_name);
v_blob blob;
v_src_offset number := 1;
v_dst_offset number := 1;
begin
insert into noc_image_liabrary (id, image_name, image_file)
values (p_id, p_file_name, empty_blob())
return images into v_blob;
dbms_lob.fileopen(v_bfile, dbms_lob.file_readonly);
dbms_lob.loadblobfromfile(v_blob, v_bfile, dbms_lob.getlength(v_bfile),v_src_offset,v_dst_offset);
dbms_lob.close(v_bfile);
commit;
end;
/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.