Link to home
Start Free TrialLog in
Avatar of sathyagi
sathyagi

asked on

Error message is: ORA-00904 invalid identifier

Can somebody help me to solve the issue----.Error message is: ORA-00904 package name.procedure name  invalid identifier
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

either you wrong the name wrong, or the logged in user does not have permissions to use that package.
Avatar of haidersyed
haidersyed

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
Avatar of sathyagi

ASKER

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

Thanks Guys!
ASKER CERTIFIED SOLUTION
Avatar of DarthMod
DarthMod
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial