Re: invalid path with UTL_FILE.FOPEN

According to the O'Reilly PL/SQL book, there is no support for using environment variables in setting utl_file_dir in the init.ora file, nor do I know how you could get a PL/SQL script itself to grab that environment variable and embed it in a path/filename that you pass to FOPEN. Your choices are either to hardcode specific directories in init.ora or to use '*' to enable writes to any directory accessible from the SERVER ITSELF. If you set it up with '*' you'll have to use the absolute path in FOPEN. Of course, you must have permission to write in the selected directory.

Keep in mind that this ONLY works for writing to files relative to the server, not a client. To write to files on the executing client you'll have to use DBMS_OUTPUT. -Brendan

In article <3547E33C.A90F6132_at_bid4u.com>,   Steve Silveri <ssilveri_at_bid4u.com> wrote:
>
> I keep getting a path exception when using UTL_FILE.FOPEN. I tried
> setting the
> parameter utl_file_dir in the parameter file with
> %ORACLE_HOME%\projects,
> but to no avail.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 30 1998 - 11:03:58 CDT