How to use bfilename
732607Nov 23 2009 — edited Nov 23 2009Hi,
I want to use the statement
src_file := bfilename(p_file_dir, p_file_name);
inside a stored procedure because I want to load a file JPG into a BLOB field of a table.
What do I have to pass as "p_file_dir"? I don't have the privilege for lunching a CREATE OR REPLACE DIRECTORY DIR_TEST AS 'c:\script'; but can I define a directory?
I've tried to passa directly p_file_dir --> c:\script but I get
ORA-22285: non-existent directory or file for FILEOPEN operation
Can you help me?
Thank you
Edited by: user12180597 on 23-nov-2009 5.22