Re: cursor

depending on the size you can as well do insert into iq_smt_tmp_assy_partnum_rd
  (col1,col2,...)
  select
   myval1,myval2,...
  from
    a_table,
    (
    c1
    ) c1
where

     condition = rs1.column_name and

to know if c1 take time just run it and do a timer

select to_char(sysdate,'DD-MM-YYYY HH24:MI SS') from dual
/

select count(*) from ( c1 )
/

select to_char(sysdate,'DD-MM-YYYY HH24:MI SS') from dual
/

then the insert may take time too if you've got a few constraints on them

--
     Antoine FERNIQUE