Oracleref dynamic cursor

the
create or replace procedure pro_cursor_type_V
as
t_tmp table3%rowtype;
type c_type is ref cursor;
cur c_type;
v_taname varchar2(100);
begin www.2cto.com
v_taname:='aa';
open cur for & # 39; select * from table3 where taname=:a order by taid desc & # 39; –a is just a placeholder for binding variables to bind with the =: symbol
using v_taname;
dbms_output.put_line(& # 39; name has & # 39;);
loop
fetch cur into t_tmp;
exit when cur%notfound;
dbms_output.put_line(& # 39; name is & # 39; || t_tmp.taname || & # 39; date is: & # 39; || t_tmp.indate);
end loop;
end pro_cursor_type_V;

the
Author blog_yuan