Using Connection Variables as arguments in Stored Procedures

[Ivan Smahin]

Hello Bart,

Wednesday, September 5, 2007, 5:25:14 PM, you wrote:

> Hi List, Ruslan


> Subject says it all:

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

Yes, it is possible.

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

set @aValue = 100;
call ABS( @aValue )
select @aValue;

And you get -100 here.



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com