If the max size over 2M

[Betty]

Hi,

I got solution, just put "set termout off" in the spool script file, then all output result will not be display on the output file.

for example:
try.sql
-- set termout off;
spool t.txt;
select empno from emp;
spool off;
set termout on;

The call @try.sql through OEM job. Then the output size will not go beyond 2M.