Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SYS.UTL_FILE Package

Re: SYS.UTL_FILE Package

From: Mohamed Buhari <mbuhari_at_assigncorp.com>
Date: 25 Jan 2000 14:58:36 EST
Message-ID: <388DFFCE.8C462465@assigncorp.com>


Yup!.

You need to add all the access directories in init.ora.This directory must be owned by oracle:dba.

utl_file_dir=/home/user/source

Mohamed Buhari
oracle dba

miaemp_at_my-deja.com wrote:

> I wrote a PL/SQL utility to output Stored Database Code. I am getting
> an exception of INVALID PATH from the package when I go to open the
> file. For example:
> fin := fopen('/home/user/source',
> 'test.pls',
> 'w');
> Does anyone have any ideas?
>
> TIA
> Eric Peterson
> Programmer/Analyst DBA
> Maurices Inc.
> eric_NOpeterson_at_mauriesSPAMMERS.inrg.com
>
> The views I have expressed are solely my own and not that of my
> company's.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 25 2000 - 13:58:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US