Converting spool and @ commands from sql plus

[Brad P]

set feedback off

set heading off

set pages 0
The following runs fine in 10g sql plus but I want to run this in pl/sql as a procedure on 11g now. I need some guidance on the coversion of spooling and using @ commands... thanks in advance, brad
-------
set lines 200

spool b:\CISStaging\CISOutFiles\CISViewsSimpleOut.txt

SELECT f_crt_rto_vw(refr_tbl_phy_nm) FROM rt_refr_tbl ;

spool off

@b:\CISStaging\CISOutFiles\CISViewsSimpleOut.txt

 

[Theod]

Hi,

if your result contains sql you can execute it this way.

BEGIN
FOR r IN (SELECT f_crt_rto_vw(refr_tbl_phy_nm) FROM rt_refr_tbl sql_txt) LOOP
EXECUTE IMMEDIATE r.sql_txt;
END LOOP;
END;