Stored procedure error

[prasson_ibm]

Hi,
I have job like

storedprocedure---->transformer----->file

I exported metadata for storedprocedure,and its exporing 83 columns.But when i run the procedure on Sql -server client,it fetches 112 columns.

When i try to manually add missing cloumns to source stage,it throws me below errors:-

Code: Select all

Stored_Procedure_0,0: Error: Wrong number or types of arguments in call to cl_ica_dwh_customer_inquiry;1
Stored_Procedure_0,0: Error occurred in call to ORPHCallActivePluginInitialize().
Stored_Procedure_0,0: The runLocally() of the operator failed.
Stored_Procedure_0,0: Output 0 produced 0 records.
Stored_Procedure_0,0: Operator terminated abnormally: runLocally() did not return APT_StatusOk

Can anyone help me to resolve the issue.


Thanks
Prasoon

[chillblue]

Hi prasson_ibm,

Just give a try with the belwo settings..

in Syntax tab ---> procedure_type:

Select as "Source" and try again.


Thanks

[prasson_ibm]

I have already selected procedure type as source