define
  row_emp employees%rowtype;
...
  select * into row_emp from employees  where employee_id = Val1;
end;

 select f1, f2, ..., fn into v1, v2, ..., vn from table1 ;
 ...
 insert into table2 values (v1, v2, ..., vn);

create table t1 (
id int,
f1 char);

insert into t1 values ( 1 , 'a');

create procedure row_test ()
define
  row1 row (id int, f1 char);
  let row1 = row(null, null); -- если значение не инициализировать то при execute будет ошибка !!!
  select * into row1.id, row1.f1 from t1 where id =  1 ; 
  -- select * into row1 from t1 where id = 1; -- -661    Number of variables does not match number of values returned.
end procedure;

update statistics for procedure row_test2;
execute procedure row_test2();

...

update statistics for procedure row_test;
execute procedure row_test();