Re: straight forward Oracle unix web solution sought

>I undertand there is WebDB (for NT and Solaris only?), Oracle Web
>Server, Oracle Application Server (v9?), PSP, Oracle Web Toolkit, OAS
>etc etc and all of this over a variety of Oracle versions.
>
>Can you point me in the right direction for a basic Oracle DB <--> Web
>solution?
>
The most "basic", in the sense of producing pages, is 9iAS's Oracle Portal (which runs fine against an 8.1.7 database). You can make simple forms, reports and (very) simple graphs by pointing and clicking. Getting Portal successfully installed and configured on the server isn't easy by my standards, though.

The most basic to set up would be the Oracle web toolkit. You put mod_plsql in with your Apache webserver, configure a Database Access Descriptor, and write PL/SQL procedures that generate the HTML pages you want. There was a good article on this by Daniel Liu in the 4th Qtr 2001 SELECT magazine. The only trouble here is that you can't just write a page with HTML tags, you write a procedure that contains calls to OWA toolkit procedures that generate tags. It's hard to look at a PL/SQL procedure and visualize the webpage it will make.

>I usually create web pages in an HTML
>tool and then add scripting to handle the data presentation.

In that case, you may want PSPs, which are like the Oracle web toolkit, but inside-out... you write a webpage (any way you want), then include the PL/SQL portions within it. I've never used it so I can't tell you how hard it is to configure.

Good luck!
- Catherine Devlin

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net