Re: Load data over web

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
Received on Tue Mar 16 1999 - 03:42:33 CST