SQL> create or replace procedure wtolentino.prc_test_dba_view as
  2    vUserName varchar2(40);
  3  begin
  4    select username
  5      into vUserName
  6      from dba_users
  7     where username = 'WTOLENTINO';
  8    dbms_output.put_line('username '||vUserName);
  9  end;
 10  /

Warning: Procedure created with compilation errors.

SQL> show errors;
Errors for PROCEDURE WTOLENTINO.PRC_TEST_DBA_VIEW:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4/3      PL/SQL: SQL Statement ignored
6/10     PL/SQL: ORA-00942: table or view does not exist
SQL> 
SQL> select count(*) from dba_users;

  COUNT(*)
----------
       139

SQL> select username from dba_users where username = 'WTOLENTINO';

USERNAME
--------------------------------------------------------------------------------
WTOLENTINO

SQL>