Re: BFILE & BLOB question (Binary file from the client machine)

Sorry about that. It is not text based forms. It's Forms version 4.0.
Do you have a solution to the problem though?

damorgan <damorgan_at_exesolutions.com> wrote in message news:<3C8E218E.9523742E_at_exesolutions.com>...
> By SQL*Forms do you mean the old character based SQL*Forms as in version
> 3, or perish the thought earlier?
>
> If so ... you do it by upgrading to software sold in this century.
>
> Daniel Morgan
>
>
>
> Noel P wrote:
>
> > Hi
> >
> > I don't have a lot of experience in Oracle. Can somebody help me here.
> > This is
> > what I am trying to do.
> >
> > I have an application where the personal information is stored.
> > Name, DOB, Sex, Address etc. Along with that I have to store a picture
> > of the person.
> >
> > When I enter a new record (FROM THE CLIENT MACHINE USING SQL*FORMS), I
> > have the
> > picture on my local machine, say C:\PERSONAL\PHOTO1.jpg.
> >
> > 1. How do you put it into the Oracle table on the server?
> >
> > Now, I have read a lot on BLOB/BFILE etc. If I use a BFILE, it talks
> > about creating logical directory and stuff, but not clear on whether
> > the file should be in a directory on the server or client. Do I have
> > to upload this file to the server first manually, OR I CAN UPLOAD THE
> > LOCAL FILE ON THE CLIENT MACHINE TO THE SERVER USING AN SQL STATEMENT.
> > (Or any other way to do it from my SQL*forms client).
> >
> > 2. Now, how can I extract the file from the database to a local
> > directory, again on the client.
> >
> > Your help is greatly appreciated.
> >
> > Thanks
> >
> > -Noel
Received on Tue Mar 12 2002 - 20:17:39 CET