$ORACLE_HOME/dbs/init<SID>.ora is the place to start looking for them.
This copy usually just includes an actual initialization file, so it's the place
to look for actual pfile location. If it is actual pfile, you can edit it right there
then (be sure to save a copy of original file if you are not completely sure
what you are doing, otherwise you may render the instance unstartable).
UTL_FILE_DIR parameter defines the list of directories to which UTL_FILE
will have access (provided that OS user running Oracle has access to them
on file system level).
As of your error message - without seeing the code that produced it, it's
hard to tell what's wrong.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Rami Huhtala" <ramirez134_at_hotmail.com> wrote in message
news:ac1562ed.0204182252.4ea6b8a0_at_posting.google.com...
> Hie
>
> I try to use package UTL_FILE.
>
> But I get Error message
> "Argument of datatype "Cursor" is not supported. "
>
> Where is the problem?
>
> Also
>
> I understand that I have to set file directory to init.ora file like
>
> UTL_FILE_DIR = /directory
>
> Where I can find this init.ora file.
>
> I try to find it from server and I found severel files, which is the right
> one.
>
> Many thanks
>
> Rami Huhtala
Received on Fri Apr 19 2002 - 03:02:42 CDT
