UTL_FILE

From: <julian_stumm_at_my-deja.com>
Date: 1999/10/06
Message-ID: <7teql4$7ig$1@nnrp1.deja.com>#1/1

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.

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. Received on Wed Oct 06 1999 - 00:00:00 CDT