How common is it to write http sites in pl/sql

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 29 Jan 2003 11:44:56 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7033C25B1@lnewton.leeds.lfs.co.uk>

Morning Marc,

this webby stuff is popular today !

I've written one single soliraty web site based on data held in an Oracle database.
I've used PSP to do it - basically, using PL/SQL procs and packages to build a dynamic web page on the fly.
It works brilliantly for me. :o)

I first started writing that PSP stuff in a 'proper' HTML editor package where you can put in 'new' tags etc like '<% stuf %>' and so on, these are passed through a commandline utility called loadpsp which converts the new tags into PL/SQL and builds a procedure in the database.

In the end, I got fed up of using PSP and loadpsp as the generated procs were, to put it mildly, very difficult to read, so I reformatted them and now just do it all in PL/SQL procs. See my post in the thread
'Website using Oracle' where I show examples of the stuff I'm on about.

HTH Cheers,
Norman.

PS. If the code you are looking at is really badly formatted, and simply uses htp.prn all over, then I suspect it was created by loadpsp. See if you can find the original source code for the psps that your predecessor wrote - they should be in 'pure' HTML and may well be more readable.

PPS. I tend to try to keep by 'get the data' logic separate from my
'print the data as html' logic, but each to their own :o)

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Marc Eggenberger [mailto:marc.eggenberger_at_power.alstom.com] Posted At: Wednesday, January 29, 2003 9:49 AM Posted To: server
Conversation: How common is it to write http sites in pl/sql Subject: How common is it to write http sites in pl/sql

Hi there.

I have been selected to alter an WebApplication from a guy that no longer works here (<-- this is gonna be fun)

He wrote the whole app as packages with the code in the procedures. In those procedures he has the sql code and he also prints out the html directly in this code.

Now for me this is extremly hard to read and I'm more used to only have stored procedures or similar on the database server and the whole html stuff is done not in the DB it but with ColdFusion, PHP, Java whatever. To have gui and data seperated ...

Is it common to write it all in procedures in Oracle? What are other pro's and con's?

Thanks for any help.

-- 
mfg
Marc Eggenberger

Received on Wed Jan 29 2003 - 05:44:56 CST