Oracle Database Discussions

Hi All,

I am having problems with using the create_directory command. I cannot find an example of UTL_FIL_OPEN that uses a directory created with the create_directory function.

Here is what I am trying:

Using 10g, I signed on as sysdba and entered:

CREATE OR REPLACE DIRECTORY MYDB_DIR;

GRANT READ ON DIRECTORY MYDB_DIR TO FRED;

GRANT WRITE ON DIRECTORY MYDB_DIR TO FRED;

Then when I queried the all_directories table, MYDB_DIR was there with owner set as SYS.

So my question is, what is the format for the UTL_FILE_DIR.open using the directory MYDB_DIR?

file_id := UTL_FILE.fopen(???????,test.dat,’W’);

Thanks,
Aaron