UNIX/SQL loop to spool files!!

I want to spool files from unix using a sql script that would
take values from another sql query within the KSH script..

unix loop
select order_date from date_tbl

for each order_Date i need to call this spool script with the value
sqlplus scott/tiger@order_db @/ordspool/order_date.sql $order_date

the order_Date.sql will spool a file for each order_date
How would i do that? Any help is appreciated...

Would it not be easier using PL-SQL ?

I need to pipe the SQL Spool to another loading program....Thats why..