Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How common is it to write http sites in pl/sql

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

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 30 Jan 2003 05:30:05 -0800
Message-ID: <1efdad5b.0301300530.10bbe8f6@posting.google.com>


What are the advantages to creating websites with the Tookit over just using Forms? Im assuming this way you get more flexibility somehow?

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA7033C25B1_at_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.
Received on Thu Jan 30 2003 - 07:30:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US