procedure test_proc
is
  l_count number;
begin
  select count(*)
  into l_count
  from test_tab
  ;
end test_proc;

create table test_tab (
  col1 number,
  col2 timestamp
);

create or replace view test_v
as
select col1 from test_tab;

MYDBA@orcl > create table test(col1 number, col12 timestamp);

Table created.

MYDBA@orcl > create procedure test_proc is
  2  l_count number;
  3  begin
  4  select count(*) into l_count from test;
  5  end;
  6  /

Procedure created.

MYDBA@orcl > exec test_proc;

PL/SQL procedure successfully completed.

MYDBA@orcl >