| 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:
> This is the state of my utl_file_dir:
>
> NUM     "NAME"       "TYPE"     "VALUE"  "ISDEFAULT  "ISSES_MODIFIABLE"
> 390     utl_file_dir    2       <null}    TRUE        FALSE
>
> "ISSYS_MODIFIABLE"      "ISMODIFIED"    "ISADJUSTED"    "DESCRIPTION"
>
> FALSE                    FALSE   FALSE        utl_file accessible
> directories list
>
> Do I have to modify the installation parameters to insert new
> accessible directories or an update could work?
>
> In article <3A422D53.3E3CFEEC_at_Unforgetable.com>,
>   Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:
> > 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.
> >
> >
yes. Received on Thu Dec 21 2000 - 12:38:22 CST
|  |  |