Re: UTL_FILE

Carlos a écrit :

> Hello,
> I want to create differentes files then i find the UTL_FILE package.
> My question : do the files have to exist or can i create them ??

You can create it

> Because in
> every sites or books, the creating file is not talking about.
> If no, how can i do without using spool (cause i can't know how many files i'll
> done) ?

file_desc := utl_file.fopen(<file_path>, <file_name>, 'w');

[Quoted] [Quoted] but the UTL_FILE_DIR parameters ( init.ora ) have to be initialize to the directory [Quoted] [Quoted] you want allow Oracle to create the file or you can choose a larger option with [Quoted] [Quoted] positioning UTL_FILE_DIR = * if you don't where you to create the files ( it's not [Quoted] a good solution i think )

Raphaël

PS: hope you understand the solution and excuse me for my English

>
>
> --
> User of http://www.foorum.com/. The best tools for usenet searching.
Received on Tue Oct 23 2001 - 18:40:24 CEST