printing entire cursor variable
793965Nov 17 2010 — edited Nov 17 2010hi all....
is there any way to print the entire cursor variable in plsql???
i have written a plsql block where i have made a cursor....the query for th cursor is working exactly fetching a number of rows....now i have declared a variable of that cursor...and then i want to print that variable by the following way...
declare
cursor c1 is select............................;
v_c1 c1%rowtype;
begin
open c1;
loop
fetch c1 into v_c1;
exit when c1%notfound;
dbms_output.put_line(v_c1);
end loop;
close c1;
end;
but this is throwing error.....wrong number or types of arguments in call to PUT_LINE
please help me out....thanks in advance....