Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

printing entire cursor variable

793965Nov 17 2010 — edited Nov 17 2010
hi 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....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2010
Added on Nov 17 2010
6 comments
10,546 views