Error while executing stored procedure

svga · Post by **svga** » Thu Mar 01, 2012 2:13 pm

Hi,

I'm getting the below error message while executing the stored procedure through Datastage. Please let me know the cause of the error. Thank you for the help....

Fatal Error: Fatal: ORA-06550: line 1, column 7: PLS-00201: identifier 'OSS_TEST.PR_PROC' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

where OSS_TEST is schema & PR_PROC is procedure name

chulett · Post by **chulett** » Thu Mar 01, 2012 2:45 pm

That's usually means a lack of execute grants for the connecting user.

svga · Post by **svga** » Thu Mar 01, 2012 2:51 pm

Thank you for your response...