? Executing a Stored Procedure With Output Parameters and A Resul tset using a Command Object 
Author Message
 ? Executing a Stored Procedure With Output Parameters and A Resul tset using a Command Object

I want to execute a stored procedure  which returna a result set and
Output parameters.

But When I try to access it using a command object, It either gives a
Result set or Output values.

Because of this I am executing twise same procedure.

Like
        AdoCMD.Execute
        if ( adocmd(5) > 0 ) then ' One of the output parameter is
greater than 0
                set rs = adocmd.execute
        end if

this is making one additional trip.

if i try

set rs = adocmd.execute

the output parameters are not set.

Is there any way to avoid this.



Fri, 02 Aug 2002 03:00:00 GMT  
 ? Executing a Stored Procedure With Output Parameters and A Resul tset using a Command Object


Fri, 19 Jun 1992 00:00:00 GMT  
 ? Executing a Stored Procedure With Output Parameters and A Resul tset using a Command Object

PRB: Output Parameters Wrong after ADO Command.Execute Call
http://support.microsoft.com/support/kb/articles/q167/9/08.asp



Fri, 02 Aug 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. ? Executing a Stored Procedure With Output Parameters and A Resul tset

2. Accessing Oracle Stored procedure output parameter from VB using RDO2.0

3. output parameter using oracle stored procedure

4. Retrive output parameters when using stored procedure in Sybase database

5. Problem with output parameter in stored procedure

6. Problems with getting output parameters from a Stored Procedure

7. Output Parameter from SQL Server Stored Procedure

8. ADO Output Parameter with Stored Procedure in SQL Server 7

9. Output Parameter of Stored Procedure can't be gotten

10. Connecting to Oracle stored procedures with both input and output parameters

11. ADO Output Parameter with Stored Procedure in SQL Server 7

12. Output Parameter from Stored Procedure

 

 
Powered by phpBB® Forum Software