Oracle Procedure Problem

create procedure tab_rows

                IS
                tab_name varchar(50);
                declare cursor all_tabs is
                        select table_name
                        from user_tables;
                begin
                        create table temptab (rowc number (10));
                        open all_tabs;
                        Loop
                            fetch all_tabs into tab_name;
                                insert into temptab(rowc) select
count(*) from tab_name;
                            exit when all_tabs%notfound;
                        End loop;
                close all_tabs;
        End;

temptab has only one column rowc(number)

Objective : ; procedure will return count(*) of all user tables.

But above procedure is giving Error :Procedure created with compilation errors.

Can anybody has workaround over it Received on Fri Apr 21 2006 - 08:05:12 CDT