set pagesize 0
set closep |
select * from cdrmgr.forecast_orders;
the above query, pick the data from tables and write flat file separateded by ‘|’ and write file in /tmp/ directory
in SQL developer it is working fine , i want to do in JDBC Adapter, which adapter service will full fill above requirement, do i need to go for adapter service or stored procedure, i have tried with customSQL adapter service but i didnot acieve this.
am using oracle database and webmethods 7.x
anil kumar ellendula