Re: UTL_FILE

On Wed, 06 Oct 1999 06:36:21 GMT, julian_stumm_at_my-deja.com wrote:

>Hi - anyone got any ideas why this won't work?
>
>CREATE OR REPLACE PROCEDURE PROBLEM
>AS
> varFile UTL_FILE.FILE_TYPE;
>BEGIN
> varFile := UTL_FILE.FOPEN
>('/tmp','data','w');
> UTL_FILE.PUT_LINE(varFile,'Hello');
> UTL_FILE.FCLOSE(varFile);
>END;
>
>I'm getting Invalid Operation.
>This is on a UNIX box
>My init.ora does have the line utl_file_dir = *
>and the database has been restarted since adding
>it - but no luck.

One quick thing to check. Does that file ( /tmp/data ) exists already? If so, are the permissions OK for the oracle database owner to write to it? Just an idea.

chris.

>
>Separately - when I try running it on a
>stanadlone PC using Personal Oracle the database
>won't start when I include the utl_file_dir line.
>It GPF's. Anyone know why?
>
>Thanks
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation