Page 1 of 1

TMyStoredProcedure Can Return Param?

Posted: Mon 29 Nov 2004 01:07
by CHIN
If i call stored procedure using TMyStoredProcedure,
some params is declare 'OUT' or 'INOUT', TMyStoredProcedure
can be auto return/update param?

Example:

Create Procedure MyValue(
IN InValue Int,
OUT ReturnResult)
Begin
Set ReturnResult = InValue * 10;
End
//

Call MyValue(12, @a)//
---------------------------------

Re: TMyStoredProcedure Can Return Param?

Posted: Mon 29 Nov 2004 12:05
by Ikar
Now this ability is enabled only for Result. Full support of OUTPUT parameters most probably will be available with MySQL Server 5.0 beta release.