begin
  select b.title
    into :loan_blk.title -- non-database field
    from book b,
         bk_copy c
   where b.book_id = c.book_id
     and c.bk_copy_id = :loan_blk.bk_copy_id;
end;