Re: Problem with some simple PL/SQL.

On 2005-07-24, Paul <paul_at_see.my.sig.com> 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.

The exact text and/or number of error messages is useful (!= "it didn't work!").

Try:
alter system set utl_file_dir='c:\temp' scope = spfile; Then restart the database.

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/