Read BFILE

From: INF/MEKKAOUI <nmekkaoui_at_lth.sonatrach.dz>
Date: Mon, 23 Oct 2000 11:38:43 -0000
Message-Id: <10658.119953@fatcity.com>

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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2014.210" name=GENERATOR></HEAD>
<BODY>
<DIV> </DIV>
<DIV> </DIV>
<DIV align=left class=OutlookMessageHeader dir=ltr> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=500320911-23102000>Hi
list,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN

class=500320911-23102000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=500320911-23102000><FONT face=Arial
size=2><SPAN class=500320911-23102000>i plan to use BFILE (external LOB) to stock  employee's photo and </SPAN></FONT>I have some problem here :</SPAN></FONT></DIV>
<UL>

  <LI><FONT face=Arial size=2><SPAN class=500320911-23102000>i copy external   photo jpg in a directory file system Netware</SPAN></FONT>   <LI><FONT face=Arial size=2><SPAN class=500320911-23102000>i create a   directory photo in the oracle database.</SPAN></FONT>   <LI><FONT face=Arial size=2><SPAN class=500320911-23102000>i create a table   emp with two columns with this description :</SPAN></FONT><SPAN   class=500320911-23102000></LI></UL>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

  <BLOCKQUOTE style="MARGIN-RIGHT: 0px">     <DIV><SPAN class=500320911-23102000></SPAN><FONT face=Arial size=2>e<SPAN     class=500320911-23102000>mpno </SPAN>NOT NULL VARCHAR2(6)</FONT></DIV>     <DIV><SPAN class=500320911-23102000></SPAN><FONT face=Arial size=2>p<SPAN     class=500320911-23102000>hoto </SPAN>BFILE</FONT></SPAN><FONT face=Arial     size=2><SPAN
class=500320911-23102000></SPAN></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE>
<UL>

  <LI><FONT face=Arial size=2><SPAN class=500320911-23102000>i insert a row with   photo=bfilename('PHOTO','photo.jpg')</SPAN></FONT></LI></UL>
<UL>

  <LI><FONT face=Arial size=2><SPAN class=500320911-23102000>i grant read system   privilege on directory photo to owner table emp</SPAN></FONT></LI></UL>
<DIV><FONT face=Arial size=2><SPAN class=500320911-23102000>the question is how
to display photo in a form with (forms developer 6.0) , do i need function to return the external photo ???</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Best Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>Nabila Mekkaoui</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>DBA </FONT></DIV>
Received on Mon Oct 23 2000 - 06:38:43 CDT