Originally posted by suhasd75
oh really????

Do u think i'll give permision to ALL users to CREATE DIRECTORY???
Dont i know this option ...

It's all the more easier to manage.. otherwise, u'll end up having n number of "directories",,,, dude...Default directories are always easier to manage.... believe me
whatever dude, give'em sysdba for all I care

For tinakh25's testcase make sure 'C:\APPS\ORDER1' is a valid path on the server, not your client.

I ran your testcase ok by changing the path to c:\temp below


SQL> show parameter utl

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string
SQL> CREATE OR REPLACE DIRECTORY MYFILE AS 'C:\TEMP';

Directory created.

SQL>
SQL> Create or Replace procedure UTLTEST as
2 f1 utl_file.file_type;
3 begin
4 f1:= utl_file.fopen('MYFILE','NEWFILE.TXT','W');
5 utl_file.put_line(f1,'1. This is a test of UTL_FILE packages');
6 utl_file.put_line(f1,'2. Oracle has added a new procedures in the package');
7 utl_file.put_line(f1,'3. We will see all the procedure one by one');
8 utl_file.fclose(f1);
9 end;
10 /

Procedure created.

SQL>
SQL> exec utltest;

PL/SQL procedure successfully completed.