Re: UTL_FILE problems. Need some help????

According to Metalink, the max line size parm can only be specified for O8.0.5 and later (Note 67949.1).

In article <Mhyf6.1631$iM6.224108_at_newsread1.prod.itd.earthlink.net>,   "G" <gennt_at_hotmail.com> wrote:
> Using 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;
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com
http://www.deja.com/