output parameters stored procedures / extended stored procedures 
Author Message
 output parameters stored procedures / extended stored procedures

I have a problem concerning the returning of stored
procedure output values in my C++ application using
ADODB

When calling a stored procedure sp_A which on his turn
calls an extended stored procedure xp_X (i.e xp_sqlmaint)
the output parameters (and return value) of sp_A cannot be
achieved in the C++ application. No error is indicated,
the value in my GetParameter call just remains unchanged

/******************/

as






else


/**********************/

When replacing the extended stored procedure by a 'normal'
stored procedure sp_B, everything works fine.
/**************/
create sp_B
as
  return 1
/**************/

Any idea or explination is wellcome.....

thx,
Henk Devolder



Sat, 02 Apr 2005 15:42:38 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Error at obtaining output parameters of the stored procedure, calling other stored procedure

2. use buffer as output parameters of extended stored procedure

3. extended stored procedure with output parameter

4. Stored Procedures vs Extended Stored Procedures

5. Calling extended stored procedure from stored procedure

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

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

8. temporary tables in stored procedures/parameter views vs stored procedures

9. ado recordsets from stored procedures, stored procedures have input parameters

10. ado recordsets from stored procedures, stored procedures have input parameters

11. Parameters in extended stored procedures using Open Data Services, urgent

12. Extended Stored Procedures accepting Real Parameters


 
Powered by phpBB® Forum Software