Re: when Oracle9i database supports J2EE 1.3 (or even 1.4)?

etechweb_at_yahoo.com (Sebastiano Pilla) wrote in message news:<1fbgqv4.mbmlli6fgua0N%etechweb_at_yahoo.com>...
> I found mentions of a templating engine, buried semi-deeply on Technet,
> but at the time it was unclear how much powerful it was, and none of the
> consultants from Oracle could tell us something about it.

When I think of "templating engine", I imagine something like JSP or the PL/SQL equivalent, PL/SQL Server Pages (PSP), where the main part of the page is straight HTML and it just includes little bits of database-specific code.

E.g., in a PSP file, you would write the HTML as usual with no worries about quoting, and include database-generated output by writing a block like <% my_stored_proc() %> or "today is <%= trunc(sysdate) %>".  The result is a database stored procedure that when called, just prints out the original HTML and inserts the database pieces where necessary. The stored procedure can generate an entire page or just part of one (for reusable elements like banners, sidebars, etc.).

I don't know how well the PSP facility is known by people using iAS -- it's documented in the database docs (Application Developer's Guide - Fundamentals).

John Received on Sat May 04 2002 - 15:51:06 CDT