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 -> How common is it to write http sites in pl/sql

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

From: Marc Eggenberger <marc.eggenberger_at_power.alstom.com>
Date: Wed, 29 Jan 2003 10:49:02 +0100
Message-ID: <MPG.18a1c1fb4f90e14f989690@localhost>


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 - 03:49:02 CST

Original text of this message

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