Skip to Main Content

SQL & PL/SQL

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!

Invalid Package Body & View

954148Aug 13 2012 — edited Aug 13 2012
Hi,
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2012
Added on Aug 13 2012
1 comment
332 views