Employee Listing

Newsgroups: comp.databases.oracle.server From: Norman Dunbar Subject: straight forward Oracle unix web solution sought Message-ID: Sender: Norman Dunbar Date: Thu, 12 Sep 2002 15:46:22 +0100 X-Newsreader: Microsoft (R) Exchange Internet News Service Version 5.5.2653.11 References: <43738f99.0209120601.29356040@posting.google.com> Lines: 120 NNTP-Posting-Host: mailhost3.lfs.co.uk X-Trace: 1031842172 reading.news.pipex.net 8512 193.129.247.6 X-Complaints-To: abuse@uk.uu.net Ok Mark, try this : Up until Monday this week, I'd never tried connecting any of my databases to the web, but my boss wanted our new Change Management system webified. So here's what I have : Oracle 8174 on 64 bit HP-UX 11:00 server. Apache as installed with 8174. (Installed by default on Minimal and Typical, but can be omitted on Custom install of 817). NO OTHER TOOLKITS OR ANYTHING ! Type this into a file on the server called emp.psp : Employee Listing <% for emp_rec in (select ename from emp) loop %> <% end loop; %>

<%= e.ename %>

Now load that into your user on the database with 'loadpsp' loadpsp -user username/password@SID -replace emp.psp When that is done, have a look on the database and check out the source code for a procedure called 'emp' owned by 'user'. That is what loadpsp does to your html file(s). Now, on the server, in $ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app add a DAD as follows : [DAD_dad_name] <<<<<<<<<<< Must be DAD_ in upper case plus some name for it in lower case connect_string = password = username = default_page = home document_table = sample.wwdoc_document document_path = docs document_proc = sample.wwdoc_process.process_download upload_as_long_raw = upload_as_blob = * reuse = Yes connmax = 10 enablesso = No <<<<<<<<<<<<<<<<<<<<<<<< MAKE SURE THIS IS 'NO' OR OT WON'T WORK !!! pathalias = url pathaliasproc = sample.wwpth_api_alias.process_download ;name_prefix = ;always_describe = ;after_proc = ;before_proc = There is a way to do this on the web itself, but it won't save the details for me :o( so I do it manually. Now, assuming your apache server is running, go to this URL in your browser : http://server/pls/dada_name/emp For example, my user is cmdb, my procedure/psp file is employees.psp I do this : http://my_server/pls/cmdb/employees And hopefully it all just works. Get onto MetaLink and/or Google and look for PL/SQL Server Pages, or PSP for details, but the above is (a) simple and (b) very quick ! HTH Regards, Norman. -----Original Message----- From: mlb3820@yahoo.com (Mark Bonneville) [mailto:mlb3820@yahoo.com] Posted At: Thursday, September 12, 2002 3:01 PM Posted To: server Conversation: straight forward Oracle unix web solution sought Subject: straight forward Oracle unix web solution sought Pardon this newbie to Oracle. We have a competent Oracle DBA in house but his knowledge falls shy of Web Admin. We have an 8.1.7 Oracle instance running on AIX 4.3. I want to connect the instance to the web. I understand Oracle comes with Apache and have a request pending to have it installed and configured on the same server as the Oracle instance. I have worked with Progress, SQL Server and DB2 and set up multiple web sites so I am passingly familiar with web architecture, html, cgi, perl etc. I have set up my own connections between dbs and web server via ksh, perl and cgi. I am hoping for a tighter integration for Oracle.