Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error(167,12): PL/SQL: ORA-00942: table or view does not exist

Tony007Feb 19 2017 — edited Feb 19 2017

hi i have the following cursor in my 12c database

cursor c_user (cp_name in varchar2) is

  select   password

  from sys.user$

  where password is not null

  and name=cp_name;

am geting the above error but in 11g is ok am running this in plugable database which table must i use in 12c

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2017
Added on Feb 19 2017
5 comments
3,562 views