Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE
nicola_at_my-deja.com wrote:
> Hi, everybody.
>
> How can I check the accessible directory list for specifying the path
> for UTL_FILE functions such such as FOPEN ??
>
> I looked in init.ora but haven't seen anything of that kind.
>
> thank you of your help,
utl_file_dir must be specified in init.ora. If it isn't, then there are no directories which are available for utl_file to work with.
If you want to check for utl_file_dir programatically, do a query against V$PARAMETER. Received on Thu Dec 21 2000 - 10:18:27 CST