Hello,
actually i've created 4 seperated stored procedures to solve this issue and i have differntiate between thier calling from .net side and everything is OK.
Regards.
ookdeh
Last Activity: Jan 22 '08, 12:55 PM
Joined: Oct 22 '07
Location:
-
first thank you Plater for your help,
actually i'm not accessing @cur from .Net side, the only thing i retreive value is "@LogsIDs" variable from .Net side ,this variable is been populated inside @cur iteration, and this which made me confused when .Net through the error message regarding the Cursor and i didn't called it anyware. i belive this error comes from SQL to .Net .Leave a comment:
-
Hello,
I've created the SP manually and not programaticly, And hereunder the SP ;
ALTER PROCEDURE SP_GetEngLogsID PerStatus_Date_ ForTrackEng_Pag e
(
@UID int ,
@Status nvarchar(10)='' ,
@isDR nvarchar(10)='' ,
@FD as datetime ='',
@TD as datetime ='',
@LogsIDs nvarchar(1000)= '' output
)
AS
Set NoCount ON
Declare @MaxId...Leave a comment:
-
Hello ,
Actually i think the main issue that asp.net can't see the @Cur variable when it is assigned inside an inner scope (the if statment scope) because this error message usually comes when the SP didn't see the "SET @Cur For " Statment and i didn't know why this comes from asp.net side although it is well from SP side.Leave a comment:
-
Cursor is a datatype used to store result for certain sql and then you can went through this result inside stored procedure ...Leave a comment:
-
Problem when invoking stored procedure with cursor from inside .net
Dear all,
i'm facing a problem with my storedprocedure which happened when i ran my web application and reach to the point where my class invoke this storedprocedure ,
my SP contains a cursor that built his sql according to certain condition, so i put the "SET @cur Cursor For....." inside the if block (definitely i've declared it under AS keyword directly) and this SP is working well inside sql server(I've tested...
No activity results to display
Leave a comment: