Re: PL/SQL Server Pages -- any comments?

Hi,

I have a site where I started with plain html from a design company and decided to use PSP's as the mechanism to serve them from the database and insert dynamic content. This started off fairly well but I ran into some issues. The first was what appears to be a size limitation of around 32k for the LOADPSP program. Another issue is that PSP's are really nothing special. Specifically, all I could identify LOADPSP does is 'wrap' the html in the procedure with htp.prn statements (hey, I can do that!) and substitute single quotes for two single quotes (think I can manage that too!).

So the method I use now to simply create the procedure to present the page manually in a text editor and load it via TOAD or procedure builder. For dynamic content I write a seperate procedure and just plug in a call from the main page.

I was by no means a PL/SQL programmer a few weeks ago when I started this (although my SQL was OK) but found it very easy to pick up with the help of some doco.

This method works very well for sites that are graphically rich. We let the designers come up with great looking pages and just plug them into the database.

I will post the URL of the site when it goes public next month.

On Wed, 12 Apr 2000 11:42:53 GMT, "steven bell" <stevenbell_at_nettaxi.com> wrote:

>Hi,
>
>I'm involved in the establishment of an ecommerce company and am interested
>in looking at using Oracle PL/SQL server pages in conjunction with an Oracle
>DB back end to build the pages. The primary reason for choosing PSP is
>accessibility to resources that have PL/SQL skills that could potentially
>pick up the PSP syntax fairly quickly......
>
>I've got some (but not much) understanding of Microsoft's ASP technology and
>I'm wondering if PSP's a similar kind of thing in terms of feature set, etc
>or whether it is poles apart.
>
>Has anyone out there any thoughts or feedback on PSP? I've had a look at the
>Oracle site (and am downloading 8.1.6 as it's not available thru Oracle
>Australia yet) but can't seem to find any good overview & example documents.
>Perhaps this is because it's quite new (or, more likely, I don't know where
>to look).
>
>Thanks in advance.
>
>-Steve
>
>
Received on Fri Apr 14 2000 - 22:31:00 CEST