Re: UTL_FILE Modules in PL/SQL

D Mei wrote:
>
> Can anyone tell me how to set up accessible locations for files in
> init.ora, in order to use utl_file module in PL/SQL?
>
> I cheked the init.ora file in our server and there was no such set up.
>
> Thanks.
>
> DMei

Put one 'utl_file_dir' for each directory you need to access, eg:

utl_file_dir=c:\orant\rdbms73\trace
utl_file_dir=c:\temp

The values must match EXACTLY the names you specify through the utl_file package -- this goes for absolute/relative path and case sensitivity, even if you are running on an OS with case insensitive file names...

Hope this helps,

Finn

-- 
--------------------------------------------------------------------------------
 Finn Ellebaek Nielsen          Oracle Associated Senior Consultant
 Ellebaek Consulting            E-mail:           ellebuk_at_post3.tele.dk
 Niels Ebbesens Vej 9, 3. th.   Mobile Phone:     +45 20 32 49 25
 DK-1911  Frederiksberg C       Mobile Phone SMS: 20324925_at_sms.tdm.dk (Subject)
 Denmark                        Private Phone:    +45 33 25 34 50
--------------------------------------------------------------------------------
 "Life is a beach and then you dive"                      "Divers do it deeper"