Page 1 of 1

Fatal Error while calling store proc

Posted: Thu Jun 16, 2011 8:05 am
by ajithaselvan
Hi,

I'm getting below error while executing the store procedure.
I'm passing 2 parameters eg:(1,'PRG').

SP,0: Failure during execution of operator logic.
SP,0: Fatal Error: Fatal: ORA-06550: line 1, column 7: PLS-00201: identifier 'LOG_TASK' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored.

I'm able to execute the same in oracle prompt.

Pls help me to fix this issue.



Regards

Posted: Thu Jun 16, 2011 8:29 am
by chulett
I'm assuming that you either don't have execute grants for the connecting user or you need to qualify the name of the procedure.