SQL & PL/SQL

Hi

I'm trying to set up a BFILE datatype in a table. I have created the directory and the current user has permissions to read and write to that folder. (The current user has the create any directory permission granted). The insert statement does not give an error but when I look at the table the BFILE column contains an error of <Value Error>.

I suspect it may be because the current user does not have server read/write permissions on the directory I'm using. Can anybody help me with a correcting this please?

Here is what I've used so far:

CREATE or replace DIRECTORY pic_dir AS 'c:\temp'

INSERT INTO picture (pic_id, filename)
VALUES (1, bfilename('pic_dir', 'image1.jpg'))