for loop dynamic sql
705271Jul 3 2010 — edited Dec 21 2012how could i write for loop using dynamic sql in package and
i don't want to use the fetch , please help ,thanks
procedure test
(in_table_name varchar2, in_com_name varchar2, in_date date) AS
l_sql varchar(2000);
begin
l_sql := 'SELECT staff_id '
|| 'from ' || in_table_name
|| 'where company_name = ' || in_cop_name
|| 'and reg_date = '|| in_date ;
for cur in (l_sql) loop
dbms_output.put_line('staff id = '||cur.staff_id);
end loop;
end;
Edited by: user11156736 on 2010/7/2 下午 11:00
Edited by: user11156736 on 2010/7/2 下午 11:01