And
select ..., dbms_lob.getlength(pict) from cust;
"KCB" <kcabaj_at_eragsm.com.pl> wrote in message
news:8812d6$6vq$1_at_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:22:56 CST
