Oracle ref Dynamic Cursor

Create or replace procedure pro_cursor_type_Vast_tmp table3 % rowtype; type c_type is ref cursor; cur c_type; v_taname varchar2 (100); begin www.2cto.com v_taname: = 'a '; open cur for 'select * from table3 where taname =: a order by taid desc '-- a is only the placeholder for variable binding and binds using v_taname with the symbol "=; 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;

Author: blog_yuan