Custom SQL issue


I am trying to execute the below SQL query from wm adapter service(custom sql).

set pagesize 0
set closep |
spool /tmp/df_order_forecast.dat
select * from cdrmgr.forecast_orders;
spool off

but getting error (42000/922) ORA-00922: missing or invalid option,

but the same sql query I can able to run from SQL Developer/ toad.

even I tried to run one by one,

“set pagesize 0” sql in wm adapter service(custom sql), but no use, getting same error

[ADA.1.316] Cannot execute the SQL statement “set pagesize 0”. "
(42000/922) ORA-00922: missing or invalid option

Can anybody help me on this

Thanks & Regards,

We solved the issue.