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 #35430 is a reply to message #35428] |
Mon, 13 February 2012 18:06 |
jjacksonRIAB
Messages: 220 Registered: June 2011
|
Experienced Member |
|
|
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.
[Updated on: Mon, 13 February 2012 18:07] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Thu May 09 13:37:38 CEST 2024
Total time taken to generate the page: 0.02146 seconds
|