Procedure to show and spool all the results

Hi All,

I want to write a procedure which is able to spool all the select statement into a text file.

eg. the result I want in the spool file:

select * from customer where customer_id=xx;
select * from order where customer_id=xx;
select * from product where product_id=yy;

The procedure should allows me to put the xx and yy value when i execute the procedure. I heard it's impossible to do unless using ref cursor? If so, how can I do it?

Thanks. Received on Tue Mar 22 2005 - 14:57:55 CST