Re: BLOB fields... Load? Print? With WHAT?

From: KCB <kcabaj_at_eragsm.com.pl>
Date: Fri, 11 Feb 2000 14:21:20 +0100
Message-ID: <8812d6$6vq$1@flis.man.torun.pl>

Find enclosed an example:
create table cust ( .... pict blob);

create directory images as '/u01/my_dir_for_pics'; grant read on directory images to your_user;

declare

    imgfil BFILE;
    imgblob BLOB;
    leng INTEGER;

begin

    imgfil := BFILENAME('IMAGES', 'your_pic.jpg');     dbms_lob.fileopen(imgfil);
    leng := dbms_lob.getlength(imgfil);     dbms_output.put_line('Length: '|| leng);     insert into cust (..., pict)

        values (...., EMPTY_BLOB)
        returning pict into imgblob;

    dbms_lob.loadfromfile(imgblob, imgfil, leng);     dbms_lob.fileclose(imgfil);
end;

That's all

Regards
Chris

"Suzanne Michelle" <NYCTSMichelle_at_yahoo.com> wrote in message news:00091c0e.9dff64fa_at_usw-ex0110-075.remarq.com...
> It seems none of our docs has anything to help us deal with
> blob fields. We have some GIFs to get into our database,
> and then print out again, preferable using SQRibe tools, or
> Oracle reports. But so far, no luck with either tool or
> either problem.
>
> Any clues as to how we get them INTO the database?
>
> Any clues as to how we print them out again?
>
> If this is device or version dependent, need to know that
> also. We are an 8i shop, with Forms 4.5 or Forms 5.0 front
> end, also Visual SQRibe, also Oracle Reports.
>
> TIA for any help.
>
> Suzanne Michelle
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Fri Feb 11 2000 - 07:21:20 CST