Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 EggenbergerReceived on Wed Jan 29 2003 - 03:49:02 CST