Re: Oracle 9i and Unix-Filesystem

On 22 Jun 2004 01:09:18 -0700, silver.schmid_at_vontobel.ch (Silver) wrote:

>Actually I'm trying to implement PL/SQL procedures to handle BFILE and
>CLOB Datatypes. The procedures and the DBMS will run on a UNIX Server
>and the external File is located on the UNIX filesystem.
>First statement in my SQL-Script is:
>"create or replace directory dir_name as '/testdir/test1';"
>to establish the alias for the subdir, in which the file (for which i
>will need the locator in the BFILE-field) is located.
>So far so good, but in a second proc, where I try to access the BFILE
>with "dbms_lob.fileopen(parm1, dbms_lob.file_readonly)" I get the
>following Oracle error:
>ORA-22285: non-existent directory or file for FILEOPEN operation

 Did you grant access to the directory to the user, i.e. grant read on directory dir_name to <user>?

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space