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
Executing MSSQL Stored Procedure
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am