Fatal Error while calling store proc

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ajithaselvan
Participant
Posts: 75
Joined: Mon Jul 12, 2010 4:11 am
Location: Chennai

Fatal Error while calling store proc

Post 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
Ajitha S
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply