At 11:51 PM 30/04/2005 -0400, Fernando Buitrago wrote:

>You'v to select 1 record into procedures, using select first 1 from
>xxxxx or use a bucle.
>You can not extract more then one record from a select.
>regards
>Fer

Completely incorrect. The FOR SELECT....INTO <variables> DO syntax
provides a set of rows through which your procedure execution can loop and
optionally output, row-by-row, as a multiple output set, using SUSPEND.

And using SELECT FIRST n in procedures is expensive and pointless, since
you can get the same set much more efficiently and cheaply in an ordered
FOR...SELECT loop.

./heLen