Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Error message is: ORA-00904  invalid identifier

Posted on 2006-06-19
5
Medium Priority
?
1,510 Views
Last Modified: 2008-03-17
Can somebody help me to solve the issue----.Error message is: ORA-00904 package name.procedure name  invalid identifier
0
Comment
Question by:sathyagi
5 Comments
 
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.
0
 
LVL 3

Expert Comment

by:haidersyed
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;

or

you may have to prefix username.packagename.procedurename
0
 

Author Comment

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

Thanks Guys!
0
 
LVL 1

Accepted Solution

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

DarthMod
Community Support Moderator
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

927 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