If you have created a stored procedure in oracle and are trying to use it in your .net code and you get the
above error while running the sp , make sure the following
1. Create the SP using the admin account
2. Grant execute rights to the user that is running the SP
3. Check if you have a public synonym for the SP in question
4. If not then create the public synonym for the SP
CREATE PUBLIC SYNONYM SYNONYM_NAME FOR ADMIN.SP_NAME;
4. Also grant execute to the public synonym also
GRANT EXECUTE ON "ADMINACCOUNT"."SP_NAME" TO "PUBLIC_SYNONYM";
5. If a public synonym is not created or you do not want to create a public synonym , then you can run the SP by appending the ADMIN schema to the SP
ADMINACCOUNT.SP_NAME
No comments:
Post a Comment