Invalid Package Body & View
954148Aug 13 2012 — edited Aug 13 2012Hi,
I have a set of 4 scripts that I have been given to run. The 1st script grants create session, table, view, procedure, and synonym to a user. Well when I go to run the 2nd script with the specified owner and password to create the pakage body and view that is in the script I receive the following error messages:
I have left out the package body name below:
package body "" has errors
I have left out the name of the view below:
Warning: View created with compilation errors.
I have run select * from session_privs; as the schema owner and can see that it has create session, create table, create synonym, create view, and create procedure.
I'm not sure why these 2 errors are coming up.
Any help is greatly appreciated!