Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Benefit of using PSP
Benefit of using PSP [message #77344] Wed, 20 March 2002 20:54 Go to next message
Messages: 1
Registered: March 2002
Junior Member
What is the benefit of using PSP over JSP and ASP?
Re: Benefit of using PSP [message #77352 is a reply to message #77344] Wed, 03 April 2002 12:03 Go to previous message
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...
Previous Topic: cartesian product
Next Topic: how to convert the html tags into text file
Goto Forum:

Current Time: Sun Aug 14 04:45:45 CDT 2022