Executing MSSQL Stored Procedure

aluthra48 · Post by **aluthra48** » Thu Jul 23, 2009 10:55 am

Hello,

I have a job that executes a stored procedure. The procedure requires one parameter, which is passed to it from a DRS stage using a select from a sql server table. Thus you can bring in one or more rows as input to the sp. The sp stage is configured to "Execute procedure for each row".

The job aborts with the following error:
APT_CombinedOperatorController,0: Fatal Error: Fatal [IBM(DataDirect OEM)][ODBC SQL Server Driver]Invalid Cursor state

The error occurs even if I pass only one row. If I pass a parameter using an environment or a local variable (one value, obviously), the job runs successfully.

Any ideas?

Thanks

Sreenivasulu · Post by **Sreenivasulu** » Fri Jul 24, 2009 1:12 am

We are also getting this issue wherein if we hardcode the parameter it works fine but not with paramter set.

Both are in the same boat

Regards
Sreeni

aluthra48 · Post by **aluthra48** » Thu Aug 06, 2009 11:56 am

A PMR with IBM has been created

Sreenivasulu · Post by **Sreenivasulu** » Fri Aug 07, 2009 9:53 am

I got the same erro using SP stage.
I checked in output tab 'returns multiple rows' and it worked.

Regards
Sreeni

aluthra48 · Post by **aluthra48** » Fri Aug 21, 2009 3:42 pm

A patch has been issued which we will aplly this Monday