I was trying to do "select count(*) from tables" in PL/SQL similar to the folowing:

declare
cursor cur is select table_name from user_tables;
v_tabname varchar2(100);
v_count number;
begin
for v_tabname in cur
loop
select count(*) into v_count from v_tabname;
/* process v_coutn */
end loop;
end;

But I got 'V_TABNAME' must be declared error message. Can anyone point out where I made mistakes?

Thanks!