SQL & PL/SQL

Hi,

I'm currentlyt using UTL_FILE.FOPEN()... UTL_FILE.PUT() to write data to a text file from a pl/sql packaged procedure.

It looks like that everytime I'm about to get above 1kb of data in the file I get an error such as:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.test_MIGRATION", line 73
ORA-06512: at line 1

Is there something I need to do to be able to write more than 1024 bytes of data?

The process is the following:

FOPEN();
LOOP
-- Write to file
END LOOP;
FCLOSE();

Thanks,

Greg