Re: utl_file_dir setting not working

Did you grant execute on sys.utl_file to the user useing the utl_file?

In article <388401BB.AC78659_at_home.com>,   Donald Candy <dcandy_at_home.com> wrote:
> How do you know it's not working? What tool are you using?
> If SQL*PLUS, make sure you are using "set serveroutput on".
> Try putting a "*" at the end of the parameter in the init?.ora,
> possibly the directory specification is invalid.
> Make sure you connect before issuing the "set" command.
> Some ideas to try.......
>
> real wrote:
>
> > For some odd reason, the setting up of utl_file_dir is not working
on
> > our Oracle 8.0.5 Database -- Solaris 2.7.
> >
> > Here's what I have done:
> >
> > Setting in init<SID>.ora specifying directory
> > Bounced instance.
> > Recompiled sys schema (as a last ditch effort).
> >
> > I've checked the all_directories view, there is nothing there.
> > I've checked in the sys.dir$ table (base table view queries) and
nothing
> > is there -- expected.
> >
> > We have this working on other servers, so I don't get what the
problem
> > is.
> >
> > Any ideas?
> >
> > Thanks in advance.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 18 2000 - 09:29:14 CST