Error message is: ORA-00904  invalid identifier

Posted on 2006-06-19
Last Modified: 2008-03-17
Can somebody help me to solve the issue----.Error message is: ORA-00904 package name.procedure name  invalid identifier
Question by:sathyagi
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16939640
either you wrong the name wrong, or the logged in user does not have permissions to use that package.

Expert Comment

ID: 16940178
send the command , logged in user
if you are logged in with other user grant permission to him using

grant execute on procedure to user_abc;


you may have to prefix username.packagename.procedurename

Author Comment

ID: 16970093
I tried using the function instead of procedure and it works fine.

Thanks Guys!

Accepted Solution

DarthMod earned 0 total points
ID: 17479229
PAQed with points refunded (250)

Community Support Moderator

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PL SQL Developer 7 67
Creation date for a PDB 5 60
Oracle TRC and TRM files are taking too much space at Oracle client computer. 5 55
UTL_FILE invalid file operation 5 45
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to recover a database from a user managed backup

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question