SQL & PL/SQL

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

Somehow, following code works fine. No errors. But, it doesn't generate file. This issue is happening in one of the prod server. Where it (similar code) used to work fine.

Where BILLAPPS is correct directory. I have access to it.

DECLARE
    GF_OUTPUT            UTL_FILE.FILE_TYPE;
    v_line  varchar2(256) ;
BEGIN
    GF_OUTPUT    :=    UTL_FILE.FOPEN( 'BILLAPPS', 'abc.txt', 'w' );
    v_line := 'testing' ;
    UTL_FILE.put_LINE( GF_OUTPUT, v_line);
    UTL_FILE.putf( GF_OUTPUT, '%s  %s %s \n', v_line, 'test', '123');
    UTL_FILE.FFLUSH (GF_OUTPUT);
    dbms_output.put_line('line is: ' || v_line) ;
    UTL_FILE.FCLOSE( GF_OUTPUT );
END ;    
/

Edited by: Arpit on Jan 17, 2012 12:37 PM