Page 1 of 1
Problem in calling stored procedure
Posted: Mon Dec 10, 2007 9:03 am
by vcsasikala
I'm using a stored procedure stage to call oracle stored procedure.
I have given the properties as below
Stored Procedure Statement : call #DSSchema#.PHR_UPD_URSULA_MASTER(:1)
Stored Procedure parameters : RUNID
RUNID is the input column name
I'm getting the error : The parameter (RUNID) is not associated with a column
Can anyone help me to clear this error.
Posted: Mon Dec 10, 2007 9:44 am
by jdmiceli
I have found issues with using the Run Stored Procedure stage as well. My solution has just been to use a before or after SQL call in a workable place. For example, if I need to run a procedure before I process another job then in that job, I will add the code that would normally call an SP from within the database engine's ide to the database stage--> Output --> SQL --> Before tab. I would also write it so that the process waits for the return code before moving on in the job. I don't work with Oracle at all, so I'm not sure how to tell you to do it there. I've met with pretty good success in SQL Server.
Hope that helps!
Posted: Mon Dec 10, 2007 12:41 pm
by chulett
I haven't had any issues with the SP stage and Oracle. We use it for a small number of user-written procs and also to call system procs.
You should have it in an anonymous block, see if this syntax works better:
Code: Select all
BEGIN #DSSchema#.PHR_UPD_URSULA_MASTER(:1); END;
Mark your single column as a Key as well, not sure if that's required but it is something we always do.