Accessing output parameter in Stored Proc. using OBDC API...
This is a discussion on Accessing output parameter in Stored Proc. using OBDC API... within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> hi pals, I would like to ge the output parameter using ODBC API, say SQLExecDirect("EXEC SP_New") . How could ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:02 PM
| ||||
| ||||
 Accessing output parameter in Stored Proc. using OBDC API... hi pals, I would like to ge the output parameter using ODBC API, say SQLExecDirect("EXEC SP_New") . How could I get the output parameter value from my application? note: forgive me if this group is not a relevant one. Thanks and Regards, shahul.      |
|
02-27-2008, 09:02 PM
| ||||
| ||||
| RE: Accessing output parameter in Stored Proc. using OBDC API... Hi For bound parameters you can call SQLBindParameter http://msdn.microsoft.com/library/de...dbc_b_729e.asp Also check out http://msdn.microsoft.com/library/de...cht10_7t2s.asp and the sample ProcessReturnCodes.cpp. More information is at http://support.microsoft.com/default...b;en-us;152174 For unbound parameters you can call SQLGetData e.g. http://support.microsoft.com/default...b;en-us;241147 John "Shahul" wrote: > hi pals, > > I would like to ge the output parameter using ODBC API, say > SQLExecDirect("EXEC SP_New") . How could I get the output parameter value > from my application? > > note: forgive me if this group is not a relevant one. > > > Thanks and Regards, > > shahul. > > > |
Linear Mode
