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

<gavinator_at_home.com> wrote in message news:38f77f0a.22307836_at_news.videon.wave.ca...
> 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!).

Of course you can do that but the question is: Do you want to? Imagine that the code is divided between a creative HTML person and a PL/SQL programmer... Wouldn't it be great if both could work on the same source and the stored procedure would be created automatically when you invoke the PSP the first time through the browser or you ran a make utility on your PSP project? This is possible with ChangeGroup PL/SQL Server Pages...

> 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.

Wouldn't it be great to avoid this manual step? And what if you update the page but forget to load it into the database?

> 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 Tue Apr 18 2000 - 22:52:22 CEST