Error at obtaining output parameters of the stored procedure, calling other stored procedure 
Author Message
 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.


Mon, 29 Oct 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Error 8162 - OUTPUT parameter error on second stored procedure call

2. Output parameter not listed for Execute SQL task that calls stored procedure

3. Retrieving OUTPUT parameters after a call to a stored procedure in C module with ESQL

4. RDA calling stored procedures with output parameters

5. odbc3 stored procedure call output parameter problem

6. Using OUTPUT Parameters in SQLServer Stored Procedures Called From VB

7. Calling a stored procedure that has an output parameter of datatype nvarchar

8. output parameters stored procedures / extended stored procedures

9. Calling a stored procedure with parameters from another stored procedure

10. Calling a stored procedure with parameters from another stored procedure

11. ADO output parameters when stored procedure raises error?

12. HELP! Stored Procedure Output Parameter Error


 
Powered by phpBB® Forum Software