Calling stored procedure using ODBC stage.

[dhiraj]

I have a job that calls a stored procedure using an odbc stage. This stored procedure is invoked multiple times(a few thousand times) by the job.

When i run this job i get an error message stating invalid cursor state.
This stored procedure has statement as shown below.

select 'MYMessage'


When i remove this statement i don't get the error. Why is this so?

I have many other jobs which are of the same structure. i.e. they invoke similar stored procedures( which has select 'MyMessage' statement) multiple times. But these other jobs run fine.

Please note that the "select 'my Message'" statement is always executed in the stored procedures.

why do i get this error in one job alone? and what is the cause of this error?

Thanks

Dhiraj

[roy]

Hi,
since you got no answers yet i can't help myself and must ask:
if all other jobs using the same method run fine what is different in this one?
could you please give more detailed info on what your doing.
(if you resolved this by now please share your solution)

awaiting your reply,