ТЕМА:

DECLARE

  ln_cnt integer;

BEGIN

  for rc in (SELECT table_name FROM user_tables) loop

    execute immediate 'begin SELECT COUNT(*) INTO :ln_cnt FROM '||rc.table_name 

    dbms_output.put_line(rc.table_name||' = '||ln_cnt);

  end loop;

  commit;

END;

ORA-06552: PL/SQL: Compilation unit analysis terminated

ORA-06553: PLS-320: the declaration of the type of this expression is incomplete

ORA-06512: at line 5

DECLARE

  ln_cnt integer;

BEGIN

	for rc in (SELECT table_name FROM user_tables) loop

		execute immediate 'begin SELECT COUNT(*) INTO :ln_cnt FROM '||rc.table_name || '; end;'

		  using out ln_cnt;

-- 		execute immediate %af_src_str_2 || rc.table_name


-- 		   into ln_cnt;


	    dbms_output.put_line(rc.table_name||' = '||ln_cnt);

	end loop;

	commit;

exception

when others then dbms_output.put_line('ERR: ' || SQLERRM);

END;