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
either you wrong the name wrong, or the logged in user does not have permissions to use that package.
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.proce durename
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.proce
ASKER
I tried using the function instead of procedure and it works fine.
Thanks Guys!
Thanks Guys!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.