Spooling in PL/SQL

Hi All,

1. 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? Someone has suggested it can done thru UTL_FILE. What you guys opinions?

2) If I only want the the procedure to display results on the screen (no spooling), how I can achieve that?

Thanks. Received on Wed Mar 23 2005 - 15:57:43 CST