Message-Id: <10658.119953@fatcity.com> From: INF/MEKKAOUI Date: Mon, 23 Oct 2000 11:38:43 -0000 Subject: Read BFILE This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C03CE5.C548612A Content-Type: text/plain; charset="iso-8859-1" Hi list, i plan to use BFILE (external LOB) to stock employee's photo and I have some problem here : * i copy external photo jpg in a directory file system Netware * i create a directory photo in the oracle database. * i create a table emp with two columns with this description : empno NOT NULL VARCHAR2(6) photo BFILE * i insert a row with photo=bfilename('PHOTO','photo.jpg') * i grant read system privilege on directory photo to owner table emp the question is how to display photo in a form with (forms developer 6.0) , do i need function to return the external photo ??? Best Regards, Nabila Mekkaoui DBA ------_=_NextPart_001_01C03CE5.C548612A Content-Type: text/html; charset="iso-8859-1"

Hi list,

i plan to use BFILE (external LOB) to stock employee's photo and I have some problem here :

i copy external photo jpg in a directory file system Netware
i create a directory photo in the oracle database.
i create a table emp with two columns with this description :

empno NOT NULL VARCHAR2(6)

photo BFILE

i insert a row with photo=bfilename('PHOTO','photo.jpg')

i grant read system privilege on directory photo to owner table emp

the question is how to display photo in a form with (forms developer 6.0) , do i need function to return the external photo ???

Best Regards,

Nabila Mekkaoui

DBA