Re: Load data over web

Thanks for responding Mike.
Some more detail would be greatly appreciated if possible. My email is coakleyj_at_hotmail.com.

Thanks
John

In article <36EE2788.C92BE86A_at_capgemini.co.uk>,   Mike Burden <michael.burden_at_capgemini.co.uk> wrote:
> I've had a go at this. We had a forms app that was deployed on the web which
> needed to upload graphics and store them in the database.
>
> Our solution was to write a simple CGI program in ProC. This used the upload
> file mechanism supported in browsers. It was basically passed the key of the
> row the data need to be loaded into as well as the data (file contents)
> selected by the user. To invoke it the the forms app simply jumped to the
> relevant url. It surprising worked quite well.
>
> This method is firewall friendly as it uses http.
>
> I can give more info if required.
>
> Forms 5 might now support this directly. What I would like to see is drag and
> drop of files straight into blobs. I see no technically reason why this can't
> be achieved but I don't know whether Oracle have implemented it. I haven't had
> time to investigate.
>
> coakleyj_at_hotmail.com wrote:
>
> > Hi to all.
> >
> > We are using Oracle 7/8 and Oracle Developer (i.e Forms 4.5/5.0).
> > We have a client-server application, whereby a user enters
> > a screen, specifies a filename (say a:\file.txt), presses a button which
> > invokes "text_io" or "sqlldr" and automatically loads the file.
> >
> > The user has the option to view the log file subsequently.
> >
> > Now, I want to deploy the same application on an
> > "Intranet/Extranet/Internet".
> > I am using Application server 4, Developer Server and client browsers using
> > either Applet Viewer or Jinitiator.
> >
> > So how do I do it? This time, when the user specifies filename
> > of a:, it's the a-drive of the Forms server that's being used?
> >
> > So how do I overcome this problem? Must I download the
> > file from the local client to the server and then operate/load this
> > file? How would I invoke such a download?
> >
> > Should I use some other tools to achieve this? Java tools?
> > What about Oracle Enterprise Manager version 2 which is
> > web-enabled?
> >
> > Any help is greatly appreciated
> >
> > Thanks
> >
> > John
> >
> > Email address is coakleyj_at_hotmail.com
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 16 1999 - 09:20:27 CST