Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: package htp

Re: package htp

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 06 Nov 2007 21:02:16 +0100
Message-ID: <fgqh81$8n6$1@news6.zwoll1.ov.home.nl>


Shakespeare wrote:

> "Frank van Bortel" <frank.van.bortel_at_gmail.com> schreef in bericht 
> news:fgnov0$emu$1_at_news5.zwoll1.ov.home.nl...

>> Jake wrote:
>>> I know this isn't going to be popular, but here goes.
>>>
>>> Looking at the HTP package, if I had to make a lot of web pages using
>>> that, it looks like it would be, well, painful, compared to other
>>> languages like PHP, Ruby, ASP, JSP for instance.
>>>
>>> Is this commonly used to create web pages using PL/SQL, or is there
>>> another preferred method?
>>>
>>> Does PL/SQL have any templating mechanism where you can create a text
>>> html template and just "fill in the blanks" procedurally?
>>>
>>>
>>> thanks.
>>>
>> What could be "painful"?
>> Just run the page through a html to plsql converter, load it,
>> and done - if you deliver the page, I'll stream it from the database
>> 10 seconds later.
>>
>> And - if you plan on doing things from with the database, some
>> form of wrapping might be handy. Application Express and Portal
>> are two examples of Oracle products doing just that.
>>
>> If you want a bit more control, take a look at
>> http://vanbortel.blogspot.com/2006/07/authentication-in-modplsql.html
>> or this:
>> http://vanbortel.blogspot.com/2006/09/modplsql-and-flexible-parameter.html
>>
>> Comes with a wrapper, too
>>
>> --
>> Regards,
>> Frank van Bortel
>>
>> Top-posting is one way to shut me up...
> 
> I think psp is in fact little more than a plsql converter... with the option 
> to put pl/sql or sql in tags. The actual converter is loadpsp.exe.
> 
> Shakepseare 
> 
> 

Correct - I was referring to the "mod pl/sql packages" - not psp. The executable is called html2plsql, and can be found here: http://www.vesterli.com/webapps101/outdated.html#tools there's a java counterpart as well.

I can still recommend the book, Sten wrote.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Tue Nov 06 2007 - 14:02:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US