Re: Q: How to Link Oracle to WWW?

From: R. A. Khan <khan_at_informatik.fh-hamburg.de>
Date: Thu, 14 Jan 1999 10:26:13 +0100
Message-ID: <369DB835.27888B44@informatik.fh-hamburg.de>

Yongun Kim wrote:

> I am a college student, and want to develop a web site for my graduation
> project.
> For the project I need to use Oracle 7 on Solaris, and want to access
> database from a web page.
>
> Would you give me some basic idea how to link Oracle to WWW?
> Java is not available for me.
> Only things I can use in my school system are Oracle7, PL/SQL, PERL and C.
>
> Thank you for your help in advance!

Java would be the easiest way. We take only the Oracle thin driver and that it is (the whole communication is done on the client site, from within java with driver connection and so on).

But you don't have it so the next "easiest" way is to use the Oracle Web Server (OWS). The admin has to configure it, which is a little bit of work (tell ows where it can connect from the Web listener to the Oracle instance, install the Oracle-htp-Package on the server, make it available), but then it is easy for a sql-developer to serve www-pages. For example, the developer would only define a procedure show nothing else, which prints a table (over http) with the htp procedure :

procedure show is

        ignore_more boolean;
        ignore_more := owa_util.tablePrint('tablename','BORDER');

end show;
-- where "tablename" is an ordinary table in oracle

and on the client-site the User would have a browser and would open the connection :

http://oracle.something.com:6781/SERVICE-NAME/show

(where the Port and the SERVICE-NAME was configured by the admin. )

This is very easy for the developer, he must not leave the sql-area, he has not to learn a new language, the only thing to learn is the htp procedures, which should be no problem . And the client needs no java browser, because all the work like formatting and so on is done on the server side.The drawback is that he is sticked to Oracle's sql-procedures. But with Oracle8i, this can be done in java from within Oracle. I am curios.

regards

--
R. A. Khan
khan_at_informatik.fh-hamburg.de
Hamburg, Germany Received on Thu Jan 14 1999 - 03:26:13 CST