LOOP question

I have code something like:
DECLARE v_column number;

CURSOR a IS SELECT column FROM table;

BEGIN OPEN a;

LOOP FETCH a INTO v_column;

mesg := (RPAD(vcolumn,12));

UTL_FILE.PUTF(file_name,'%s\n',mesg);

UTL_FILE.PUT_LINE(file_name,' . ');

UTL_FILE.FFLUSH(file_name);

EXIT WHEN A%NOTFOUND; END LOOP; END;

• End of code

When I look into file_name, the last row is always in there TWICE!

What am I doing wrong? TIA

Ian Crozier Received on Wed Sep 15 1999 - 15:10:14 CDT