Oracle ref Dynamic Cursor

Oracle ref Dynamic Cursor:

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
V_taname: = 'a ';
Open cur for 'select * from table3 where taname =: a order by taid desc '-- a is only a placeholder for the variable to be bound with the =: symbol.
Using v_taname;
Dbms_output.put_line ('name ');
Loop
Fetch cur into t_tmp;
Exit when cur % notfound;
Dbms_output.put_line ('name: '| t_tmp.taname | 'date:' | t_tmp.indate );
End loop;
End pro_cursor_type_V;