I have a script to spool a huge select result, for example:
"spool result.txt;
select * from emp;
spool off;
The records are over 20000 lines.

This script execute well through sql*plus command line, but when I use OEM job to run it, the job failed because of "output truncate".

Could anyone has good idea?