When I try to create a simple procedure like this:

create or replace procedure myproc IS

cursor my_crsr IS
select * from dba_users;


I get this on the dba_users table:
PL/SQL: ORA-00942: table or view does not exist

I am using an account with DBA role and I can easily query the dba_users view from SQLPlus.

Why when I try to use in a procedure do I get this error?