Subject Re: [firebird-support] How to assign the result of SELECT to a variable in a procedure
Author Ann W. Harrison
peter_nn0 wrote:
> Hi,
> In a stored procedure, I want is to assign the result of a SELECT
> statement to a variable - but can't make it work. I try something like
> return_var = select LNAME from WORKERS where WORKERS.ID
> = :proc_parameter;

select W.LNAME from WORKERS W
WHERE W.ID = :proc_parameter
INTO :return_var