I did not posted the entire code because I was think no relevant.
But, I use another way to return my responses, through
My code already so changed!
Tks for response.
1. You want to add 'set nocount on' to the begining of the procedure.
2. It's by design that SQL Server does not send back the values for the
return code or output parameters until the end of all result sets for the
procedure. So, you want to adjust your code accordingly.
3. I do not see the update code. You might want to post a complete text so
we can see.
RAC v2.2 & QALite!
> I have a procedure that executes an UPDATE and after, some output
> are set with determined values.
> The problem is, after the UPDATE statment, all following variables are
> reseteds to null value!
> If I remove/comment the UPDATE code, the output variables are returned OK
> my application (uses ADO 2.5/2.6, via command object).
> Anyone knows happen?
> The code is look like this:
> CREATE PROCEDURE spsml_GetDocument
> -- get resultset
> --set the variables
> Tks in advance!