|
Re: Benefit of using PSP [message #77352 is a reply to message #77344] |
Wed, 03 April 2002 12:03 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
PSP is really basic and is limited to creating Stored procedures (no packages). Using the htp, owa* etc packages you can do all the HTML you want in your pl/sql without limiting yourself. PSP, JSP and ASP try to separate the HTML for the pl/sql data access and logic. In my experience, JSP still requires you to write packages if you don't want to expose all your SQL. ASP is a good product, is widely used and MS provide rapid appliaction developemnt tools for developing ASP. The JSP I did was all in an editor and took ages. ASP is limited to MS s/w (generally on tel platforms) - (maybe not completely true - Apache has a MOD_ASP module).
Oracle is moving away from generating HTML in the database (using pl/sql) and is moving towards a 3-tier model where the HTML is done in Java. For small to big, PL/SQL web pages are probably fine. Probably couldn't support Amazon size site easily though...
|
|
|