UTL_FILE Problems. Can some one help?????

From: G <gennt_at_hotmail.com>
Date: Mon, 05 Feb 2001 13:55:05 GMT
Message-ID: <Zgyf6.1627$iM6.223924@newsread1.prod.itd.earthlink.net>

sing the following snippet against a 5.1.5.1.1 installation, I am receiving a 'ORA-01403: no data found' error. I have included the workaround that used to work for this, which is to open the file, close it, and reopen it again before writeing to the file. This does not work. There are no issues with 8.0.5 or 8.1.6.
Is there another workaround?

The output for this snippet is:

Inserting line
Error
ORA-01403: no data found

SET SERVEROUTPUT ON
DECLARE
v_file_handle UTL_FILE.FILE_TYPE;

BEGIN
v_file_handle := UTL_FILE.FOPEN('utl_file_directory','Test.txt','w',10240); UTL_FILE.FCLOSE(v_file_handle);
v_file_handle := UTL_FILE.FOPEN('utl_file_directory','Test.txt','w',10240);

DBMS_OUTPUT.PUT_LINE('Inserting line');
UTL_FILE.PUT_LINE(v_file_handle,'Test line'); DBMS_OUTPUT.PUT_LINE('Line Inserted');

UTL_FILE.FCLOSE(v_file_handle);

EXCEPTION
WHEN OTHERS THEN
UTL_FILE.FCLOSE(v_file_handle);
DBMS_OUTPUT.PUT_LINE('Error');
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END; Received on Mon Feb 05 2001 - 07:55:05 CST