Re: PL/SQL Standard packages

From: <Solomon.Yakobson_at_entex.com>
Date: 1997/02/03
Message-ID: <854983998.22921_at_dejanews.com>#1/1


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 <32F5AB60.41C6_at_cesca.es>,
  Daniel Pinyol <dpinol_at_cesca.es> wrote:
>
> Hello to all PL/SQL programmers,
> has anybody tried to use UTL_FILE to write files from
> a PL procedure? I didn't succeed. Always got the message:
>
> invalid_path:file location or name was invalid
> after 'fopen'. I tried with any path, and always the same.
>
> Can anybody give a good clue?
> Is there any good documentation/examples of Oracle Standard
> Packages?
>
> Thanks a lot
> I'll appreciate email answer to : dpinol_at_cesca.es
> --
> -----------------------------------------------------------------------
> 4 Daniel Pinyol Laserna E-Mail: dpinol_at_cesca.es
> 44
> CCCC 4444 Centre de Computacio i Comunicacions de Catalunya (C4)
> CC C 4 Centre de Supercomputacio de Catalunya (CESCA)
> CC
> CC C Gran Capita, 2-4 (Ed. Nexus) Phone: (+34 3) 205 64 64
> CCC E-08034 Barcelona Fax: (+34 3) 205 69 79
> -----------------------------------------------------------------------

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Mon Feb 03 1997 - 00:00:00 CET

Original text of this message