Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with some simple PL/SQL.
Paul wrote:
> "Dave" <x_at_x.com> wrote:
>
>
> >> utl_file_dir='D:\Paul'
>
> >when logged into sqlplus
>
> >do
> >show parameter utl_file (make sure it is set in your current session)
>
>
> NAME TYPE VALUE
> ----------- ----------- ------------------------------
> utl_file_dir string
>
>
>
> No value is apparently set.
>
>
> It's definitely in the spfile. Any ideas as to how I can set it? I
> tried
>
> SET utl_file_dir = 'D:\Paul';
> SET utl_file_dir = D:\Paul;
>
>
> Neither of which worked.
>
>
> Thanks for your input.
>
>
> Paul...
>
>
>
> --
>
> plinehan __at__ yahoo __dot__ __com__
>
> XP Pro, SP 2,
>
> Oracle, 9.2.0.1.0 (Enterprise Ed.)
> Interbase 6.0.1.0;
>
> When asking database related questions, please give other posters
> some clues, like operating system, version of db being used and DDL.
> The exact text and/or number of error messages is useful (!= "it didn't work!").
> Thanks.
>
> Furthermore, as a courtesy to those who spend
> time analysing and attempting to help, please
> do not top post.
You've been given the proper answer, yet fail to use it. Here it is again; hopefully you'll make use of the information and be finished with this thread:
alter system set utl_file_dir='D:\Paul' scope=spfile;
Then RESTART your database. The utl_file_dir parameter should then be set.
David Fitzjarrell Received on Sun Jul 24 2005 - 15:27:04 CDT