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

Marc Eggenberger wrote:
> 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.

WebDb was all PL/SQL, Portal still is to a great extend.

Frank Received on Thu Jan 30 2003 - 13:40:15 CST