Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with some simple PL/SQL.

Re: Problem with some simple PL/SQL.

From: <fitzjarrell_at_cox.net>
Date: 24 Jul 2005 13:27:04 -0700
Message-ID: <1122236824.438097.95440@g44g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US