Home » U++ Library support » U++ SQL » Is it possible to call a stored procedure with an output parameter?
Re: Is it possible to call a stored procedure with an output parameter? [message #35431 is a reply to message #35430] |
Mon, 13 February 2012 18:58 |
|
mirek
Messages: 13976 Registered: November 2005
|
Ultimate Member |
|
|
jjacksonRIAB wrote on Mon, 13 February 2012 12:06 | No problem at all.
I know that stored procedures are being executed in the same form. If I do this:
SQL.Execute (
"{call stored_procedure_x (?,?,?)}",
item.A,
item.B,
item.C
);
The stored procedure IS being executed and runs, but item.C is an output parameter and isn't being populated, obviously. Performing a SQL.Fetch() doesn't show any returned rows either.
It appears there is some other medium by which this output parameter is assigned. Other places suggest an RPC mechanism whereas in the past MSSQL relied on returning a result set.
Irritating.
|
MSSQL package is based on ODBC, after going through ODBC docs and out code a bit, it looks like we do not support it yet - but it is desirable to add such support. I might look into it in during this or next week, contributions in this area are welcome as well!
Mirek
|
|
|
Goto Forum:
Current Time: Thu May 09 11:37:13 CEST 2024
Total time taken to generate the page: 0.02852 seconds
|