I have a procedure where I want to loop through the users. I thought I could do something like:
FOR PROD_USERS IN (SELECT USERNAME FROM SYS.dba_users WHERE USERNAME LIKE '%PROD%')
however, during compile it stops and says the table doesn't exist (ORA - 00942)
I can however access it from the same schema that I have the package in.
how do I get at the usernames/schemas inside PLSQL?