Re: PL/SQL file I/O HELP

Every directory you are going to access must be specified in INIT.ORA by adding UTL_FILE_DIR = <path> lines. Only then your directories will be accessible to FOPEN.

Solomon.Yakobson_at_entex.com

In article <5f0ijs$1oe2$1_at_news.missouri.edu>,   c581534_at_sp2n09.missouri.edu () wrote:
>
> Hi there:
> I came cross one problem using fopen procedure within oracle PL/SQL
> UTL_FILE package. I kept getting exception indicating invalid path. I'm
> accessing the ORACLE server through a UNIX machine. Does anyone can
> give me some suggestion on this. THANKS a lot. The followig is the
> procedure I used to open a file:
> UTL_FILE.FOPEN('dir path', 'filename' 'r');
>
> --
> ========================================================================
> Weixing Chen
> c581534_at_showme.missouri.edu
> Weixing_Chen_at_muccmail.missouri.edu
> =======================================================================

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet