Re: Load picture from LONG to forms

Peter,

As far as I remember it is not possible. I used to workaround this with base table items.

Regards,
Karen Abgarian.

Peter Koch wrote:

> 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 Mon Sep 20 1999 - 09:08:35 CDT