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!