Re: Problem with some simple PL/SQL.

"Paul" <paul_at_see.my.sig.com> wrote in message news:m4p7e19dqd8j5cepv1rinbbgnae4dns7d2_at_4ax.com...
>
>
> "Dave" <x_at_x.com> wrote:
>
>>did you set utl_file_dir parameter to D:\Paul ?
>
>
> Both as
>
> utl_file_dir=D:\Paul
>
> and
>
> utl_file_dir='D:\Paul'
>
>
> Neither works, but it would appear that the without commas is the
> Oracle way, from other file parameters in the init.ora.55200519471file
> in my pfile dir in the D:\oracle\admin\MyDB\pfile directory.
>
>
>
> 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.

when logged into sqlplus

do

show parameter utl_file (make sure it is set in your current session) Received on Sun Jul 24 2005 - 14:24:14 CDT