Error at obtaining output parameters of the stored procedure, calling other stored procedure
Error at obtaining output parameters of the stored procedure, calling other stored procedure
Author
Message
igor #1 / 1
Error at obtaining output parameters of the stored procedure, calling other stored procedure
From ASP we call the procedure usp_one MS SQL 7.0, which through linked server calls(causes) the procedure usp_two MS SQL 6.5, placed on other computer. Both procedures have both input, and output parameters. The problem consists that in output parameters of the first procedure the values output parameters second (are received by way of their following in the second procedure), and the values output of parameters of the first procedure are lost. Certainly, the successful procedure call usp_one (is present in view of an only return code) happens, only if the types output of parameters under the order of their following coincide or can be converted by default.