Re: Oracle 9i and Unix-Filesystem

silver.schmid_at_vontobel.ch (Silver) wrote in message news:<31e8516b.0406220009.9f4aab2_at_posting.google.com>...
> Hi,
> 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
>
> Can anybody help?
>
> Thx and regards
> Silver Schmid

You'll need to set the static parameter utl_file_dir, if you already didn't set it, and bounce the db. Utl_file_dir allows a colon-separated list.

Hth
Sybrand Bakker
Senior Oracle DBA Received on Tue Jun 22 2004 - 09:45:08 CDT