Page 1 of 1

Error while executing stored procedure

Posted: Thu Mar 01, 2012 2:13 pm
by svga
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

Posted: Thu Mar 01, 2012 2:45 pm
by chulett
That's usually means a lack of execute grants for the connecting user.

Posted: Thu Mar 01, 2012 2:51 pm
by svga
Thank you for your response...