Maarten Boekhold wrote:
Joe Conway wrote:
Gavin Sherry wrote:
Do you have any idea about databases returning result sets from SQL procedures (ie, not functions).
As other's have pointed out, this is very common in the MS SQL Server world (and I believe Sysbase also supports it). It works like:
And these databases also return a result status/value from the stored procedure. IIRC this result is limited to an int value.
Maarten
Yes, MS SQL returns an int as far as I know (all the procs I use return an int), but in theory it can be any type.
From my useage, the return parameter (if requested) is returned as the first out parameter.
Ie, from JDBC, my CallableStateme is of the form: "? = Call dbo.MyProc( ?, ?, ? )" so I can simply use cs.getInt( 1 ); to get at that value. If I don't ask for the return code, then I don't receive it.
Peter
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
