Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error when executing procedures

I have created a procedure and when I try to execute this, it's showing a common error for all the procedures I have created: "Procedure created with compilation errors."

I have created a procedure and when I try to execute this, it's showing a common error for all the porcedures I have created: "Procedure created with compilation errors." When I execute this it's showing:
ORA-06550
object  scott.(obj name) is invalid
statement ignored
If the procedure is not owned by SCOTT, then the procedure's owner must be granted privileges directly. If you granted privileges to the procedure's owner through a role, then the procedure cannot see the object. Procedures require the privileges be granted directly, not through a role.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close