Monday, 8 December 2014

PLS-00201: identifier "sp_name" must be declared

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