Create directory in DB

[mcl]

Hi,

If I create a directory for loading files in to clobs via a stored proc do I need to register the Unix dir in utl_file_dir in init.ora?

i.e.
create directory test as '/tmp';

The SP will access test to load files into CLOBS using the
DBMS_LOB package.

regards,

MCL

[lesstjm]

yes you have to register the directory in util_file parameter.Oracle also has to have right to that directory in unix.