Return
-
Title
Getting 'table or view does not exist' when trying to create a procedure which queries DBA views. -
Description
When logging in as a user with DBA privileges, and trying to create the following prodecure:
create or replace procedure myuser as
cursor mycur is
select username from dba_users;
begin
for myrec in mycur
loop
dbms_output.put_line(myrec.username);
end loop;
end;The following errors are displayed:
[Error] ORA-00942 (3: 22): PL/SQL: ORA-00942: table or view does not exist
[Error] PLS-00364 (8: 26): PLS-00364: loop index variable 'MYREC' use is invalid
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.