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


Regards


Ann