Calling stored procedure using ODBC stage.
Posted: Thu Aug 26, 2004 7:39 pm
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
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