Skip to Content
0
Former Member
Nov 24, 2009 at 11:56 AM

Invalid Cursor State in Query manager case of stored procedure

282 Views

Hi Experts!

I have a stored procedure, but when running from sap in query manager,i get an error message :invalid cursor state.

I have tried 3 methods to run, but no success.

1. exec jovnyilv_sap '2009.01.01','2009.01.31','XXXX'

2./Querybegin/

Declare @enap datetime

Declare @unap datetime

Declare @item char(20)

Set @enap='2009.01.01'

Set @unap='2009.01.31'

Set @item='KUN0001'

exec jovnyilv_sap @enap,@unap,@item

/Query end/

3./SELECT FROM [dbo].[OINM] T0/

declare @fromdate as datetime

/* WHERE */

set @fromdate = /* T0.DocDate */ '[%0]'

/SELECT FROM [dbo].[OINM] T1/

declare @tilldate as datetime

/* WHERE */

set @tilldate = /* T1.DocDate */ '[%1]'

/SELECT FROM [dbo].[OINM] T2/

declare @item as datetime

/* WHERE */

set @item = /* T2.ItemCode */ '[%2]'

exec jovnyilv_sap '[%0]','[%1]','[%2]'

Any idea how to run it directly from sap busines one?

Thanks in advance!