Hi,

What I currently have is West-Wind on an IIS server.

To talk to Oracle I use the http functions in wwipstuff.

On the Oracle side, there is the Oracle Application Server OAS which is really Apache. (West-Wind will run on Apache although not optimized for it.) I communicate with Oracle by calling stored procedures though the PL/SQL Gateway and the PL/SQL Web Toolkit.

Chapter 8 of 'Professional Oracle 8i Application Programming with Java, PL/SQL and XML' from Wrox press describes the PL/SQL Web Toolkit. (Even if you don't go this route the book describes many other options.)

My Oracle DBA likes the security of only allowing contact to the database through stored procedures. He feels the JDBC and ODBC are not secure enough.

With your knowledge of Oracle SPs and West-Wind your should have no problems writing an application.

Hope this helps,

Paul

>...by restrictions. I have been asked to develop an intranet application for the Agency I work for. I can not use ASP or IIS. We use Netscape as our web server software on an NT4 server. About the only tools I can use is HTML and VBScript [or Java Script]. I can create, install and execute COM DLLs and VFP runtimes on the server. I will need to run queries against an Oracle database, and send the results back to the browser. I will also need to allow the user to add/edit records and send back to the Oracle DB. How badly hog-tied am I? Am I wasting my time trying to do this under these limits? Do I have any chance of succesfully doing this? I have 2 West-Wind web sites running quite successfully and very easily. So all these restrictions are very disappointing knowing I could do this quickly and easily if I did not have these restrictions. TIA!