Re: Connecting to Oracle from a Web browser?

Ernest Craddock <in1054_at_wlv.ac.uk> wrote in article <63qbgp$n1l_at_ccuh.wlv.ac.uk>...
> I have a project to send a pre-set query to Oracle, via a Web server,
> from a Web browser. My solution will ideally pass the form-based user
> input to the Web server, which will in turn pass the query to Oracle.
> The completed query will then return via the same route to the Web
> browser and display the result.

It depends on the platform and the web server software. The first answer will be to write a CGI, however there are other options also available.

Platform: NT Web Server: IIS
Read up on the HTX option of IIS. Basically you create two files. The first one (IDQ extension I think) contains the ODBC datasource to use and the SQL query with parameters. The second file (HTX) contains the HTML format for dislaying the data.

Second option is to use the ASP (Active Server Pages) functionality of IIS. ASP embeds advance scripting into a HTML page. When IIS reads the page, it executes the script and send the resulting page to the browser (basically the opposite where java/vb script is executed by the browser).

Platform: various Web Server : Oracle Web Server Use the HTTP PL/SQL package and write a stored procedure that produces dynamic html.

Platform: Unix Web Server: Netscape/Apache etc. Write a Perl CGI. Or write a Unix shell CGI (easier if you don't know perl). You will need to read up on the CGI specs and determine a safe method of parsing the QUERY_STRING when using a Unix shell script as a CGI.

regards,
Billy Received on Thu Nov 06 1997 - 00:00:00 CST