PSP
From Oracle FAQ
PL/SQL Server Pages (PSP) is a technology similar to ASP (Active Server Pages) and JSP (Java Server Pages).
The basic design (HTML page) is created in a visual tool, for instance an HTML designer and the PL/SQL code (also called scriptlets) is embedded within special tags. Only the absolute minimum of PL/SQL will have to be written and the HTML designer and PL/SQL programmer can share the same file. A PSP file is compiled into a PL/SQL stored procedure, which means that the PSP compile is used during the development phase only.
History[edit]
PSP was first introduced with Oracle 8i (8.1.6).
Sample PSP pages[edit]
<%@ page language="PL/SQL" %>
<%@ plsql procedure="hello" %>
<%@ plsql parameter="username" default="NULL"%>
<HTML>
<HEAD><TITLE>Hello User</TITLE></HEAD>
<BODY>
<% BEGIN
IF username IS NOT NULL THEN
%>
Hello <%= username %>
<%
ELSE
%>
No username provided!
<%
END IF;
END;
%>
</BODY>
</HTML>
A more complicated example:
<%@ page language="PL/SQL" %>
<%@ plsql procedure="Parameters" %>
<HTML>
<HEAD><TITLE>This is a Test PSP Page</TITLE></HEAD>
<BODY>
<h1>List of database parameters:</H1>
<TABLE>
<% FOR parm IN (select name, value from sys.v_$parameter
order by name)
LOOP
IF parm.value IS NULL THEN
parm.value := 'no value';
END IF;
%>
<TR>
<TD><%= parm.name %></TD>
<TD><%= parm.value %></TD>
</TR>
<% END LOOP; %>
</TABLE>
</BODY>
</HTML>
Deploying PSP pages[edit]
To compile a psp file, say hellp.psp:
loadpsp -replace -user name/pass hellp.psp
Also see[edit]
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
