Using Connection Variables as arguments in Stored Procedures

[Bart Pietercil]

Hi List, Ruslan


Subject says it all:

Can I use connection variables (@-variables) as arguments in Stored  
Procedures

ie:

CREATE PROCEDURE ABS( INOUT ioValue long )
BEGIN
     IF ioValue < 0 THEN
          ioValue = -ioValue;
     ENDIF
END


and now I can do this:

set @aValue = 100
call ABS(@aValue)
get @aValue --> should now be -100

thx

Bart