I am trying to execute a Sql-Server Stored procedure from Datasage parallel job and my job is like this:-
RowGen(1 row) ---->Stored Procedure stage ----> peek stage
I have imported the metadata from TableDefinition--> Stored Procedure Def.
I have selected below setting in StoredProcedure Stage:-
General Tab:
-------------------------------
Database Vendor: MySQL Server
Syntex Tab:
-------------------------
Procedure Type: Transform
Procedure Name: dbo.UP_IN_AMBIT_PRICE;
Procedure call Syntex: EXEC dbo.UP_IN_AMBIT_PRICE;
Parameter Tab:
------------------
I removed Return Value from parameter name since in output link I checked Procedure status to link.
Input Tab:
-----------------
Unchecked to Forward Raw data and Execute procedure for each row.
Output Tab:
--------------
Checked procedure status to link and procedure allow multiple rows.
Now when I am executing the job I am getting below error message:
Code: Select all
Stored_Procedure_5,0: Failure during execution of operator logic.
APT_CombinedOperatorController,0: Fatal Error: Fatal: Wrong number or types of arguments in call to dbo.UP_IN_AMBIT_PRICE;
Thanks
Prasoon