straight forward Oracle unix web solution sought

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 12 Sep 2002 15:46:22 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702A44435@lnewton.leeds.lfs.co.uk>

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 :

<html>
<head>
<title>Employee Listing</title>
</head>
<body>

<table>

<% for emp_rec in (select ename from emp) loop %>
<tr> <td> <%= e.ename %> </td> </tr>
<% end loop; %>

</table>
</body>
</html>

Now load that into your user on the database with 'loadpsp'

loadpsp -user username/password_at_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 = <SID or alias as above in loadpsp> password = <password as above in loadpsp> username = <username as above in loadpsp> 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_at_yahoo.com (Mark Bonneville) [mailto:mlb3820_at_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.

<SNIP>
Received on Thu Sep 12 2002 - 09:46:22 CDT