-
dba_users: table or view doesn't exist
When I try to create a simple procedure like this:
create or replace procedure myproc IS
cursor my_crsr IS
select * from dba_users;
begin
commit;
end;
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|