Re: [SQL] function parameters/output values

Chapter 4 of the programmer's guide.

On 2000-01-12, Thomas Leavitt mentioned:

> I would like to know if function parameters are used to pass output values
> back to the function.
> 
> e.g.
> 
> create function func1(p1 varchar,p2 varchar OUTPUT, p3 varchar OUTPUT)
> BEGIN
>     SELECT p1 = t.foo1, p3 = t.foo2
>     FROM test_table t
>     WHERE foo3 = p1
> END
> 
> DECLARE p2 varchar(50), p3 varchar(50)
> CALL func1('abc',@p2 out,@p3 out)
> PRINT @p2
> PRINT @p3
> --
> Thomas Leavitt -- thomas.leavitt@clickrebates.com; 408-591-3342
> Co-Founder/COO, ClickRebates.Com, Inc. (www.clickrebates.com)
> Get Paid What You're Worth!
> 
> Sign up for our pre-launch guest list and refer your friends!
> 
> Or use our working prototype at www.clickrebates.org to "Surf for a Higher
> Cause" (earn money for charity)
> 
> 
> ************
> 
> 

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden