UTL_FILE
From: <julian_stumm_at_my-deja.com>
Date: 1999/10/06
Message-ID: <7teql4$7ig$1_at_nnrp1.deja.com>#1/1
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.
Date: 1999/10/06
Message-ID: <7teql4$7ig$1_at_nnrp1.deja.com>#1/1
[Quoted] 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
[Quoted] 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 CEST