Re: PLS-00306: wrong number or types of arguments in call to '||'

Try This:

declare

    cursor u_tab is select table_name from user_tables;

begin

    execute immediate 'create global temporary table temp_tab1 ( col_count number)';

    for u_tab_rec in u_tab
    loop

        execute immediate 'insert into temp_tab1 select count(*) from ' || u_tab_rec.table_name;

    end loop;
end; Received on Wed Sep 01 2004 - 09:03:47 CDT