Re: When to use PL/SQL Server Pages?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 16 Nov 2001 10:03:48 +0000
Message-ID: <3BF4E484.36A_at_yahoo.com>


kdame wrote:
>
> I'm having trouble understanding when to use PL/SQL Server Pages as
> opposed to a regular PL/SQL package. I'm gathering that PSP's are
> html pages with embedded PL/SQL, kind of like JSP or ASP, and they are
> stored in the database.
>
> Other than for the ease of HTML programming, what are the benefits to
> using PSP? Is there any difference in performace compared to a PL/SQL
> package?
>
> Thanks in advance!

Main difference is:

PL/SQL "pure" means coding ALL of your html in PL/SQL. PSP is more for when you've got an existing set of (say) static html and you'd like to add some dynamic content.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Fri Nov 16 2001 - 11:03:48 CET

Original text of this message