Load picture from LONG to forms

I would like to load a picture stored in a LONG RAW column into a non basetable picture-item of a forms application.

Here's an example for what I want to do:

EMP:   emp_id     number(10)   not null
       emp_name   varchar2(50) not null
       emp_pic_id number(10)       null

PICS:  pic_id   number(10) not null
       pic_data long raw

What do I have to do in the post-query trigger of the EMP-block to show the employees picture from the PICS-table?

IF :emp.emp_pic_id IS NOT NULL THEN
  SELECT pic_data INTO :emp.dsp_picture_item     FROM pics
   WHERE pic_id = :emp.emp_pic_id;
END IF; does NOT work as one cannot select LONG fields into picture-items.

Thanks

Peter Koch

--
Peter Koch <Koch_at_Math.Uni-Duisburg.DE>      phone: 49 203 379-2698
Department of Mathematics                     fax: 49 203 379-3139
University of Duisburg, Lotharstrasse 65, 47048 Duisburg - Germany