Load picture from LONG to forms

From: Peter Koch <koch_at_math.uni-duisburg.de>
Date: 18 Sep 1999 09:17:57 GMT
Message-ID: <7rvlc5$1uk$1@news-hrz.uni-duisburg.de>

Dear readers:

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 Received on Sat Sep 18 1999 - 04:17:57 CDT