Link to home
Start Free TrialLog in
Avatar of chalie001
chalie001

asked on

error in my cursor

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;  

Open in new window


am geting the above error but in 11g is ok am running this in plugable database
ASKER CERTIFIED SOLUTION
Avatar of VanDongen Consulting
VanDongen Consulting
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chalie001
chalie001

ASKER

i did this
SQL> connect /as sysdba
Connected.
SQL> GRANT SELECT ON USER$ TO ils;

Grant succeeded.

SQL> commit;

Commit complete.

SQL> connect usernmae/pswd;

but still geting error
Warning: Package Body created with compilation errors.

SQL> show error
Errors for PACKAGE BODY CALMAIN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
277/7    PL/SQL: SQL Statement ignored
279/14   PL/SQL: ORA-00942: table or view does not exist
430/11   PL/SQL: SQL Statement ignored
436/18   PL/SQL: ORA-00942: table or view does not exist
623/10   PL/SQL: SQL Statement ignored
627/32   PL/SQL: ORA-00942: table or view does not exist

Open in new window

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
grant