Re: Problem with some simple PL/SQL.

From: Dave <x_at_x.com>
Date: Sun, 24 Jul 2005 20:17:36 GMT
Message-ID: <AHSEe.76466$G8.38449@text.news.blueyonder.co.uk>

"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message news:dc0slg$1ah$1_at_klatschtante.init7.net...

> 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
>

except replace the directory for that which you want Received on Sun Jul 24 2005 - 15:17:36 CDT