Mega Code Archive
Htp package demo
<![CDATA[
SQL> CREATE OR REPLACE PROCEDURE HelloWorldProcedure AS
2 BEGIN
3
4 htp.htmlopen; -- <HTML>
5 htp.headopen; -- <HEAD>
6 htp.htitle('HelloWorldProcedure'); -- <TITLE>HelloWorldProcedure</TITLE>
7 htp.headclose; -- </HEAD>
8 htp.bodyopen; -- <BODY>
9 htp.line; --
10 htp.print('Hello world.'); -- Hello world.
11 htp.line;
12 htp.bodyclose; -- </BODY>
13 htp.htmlclose; -- </HTML>
14
15 END HelloWorldProcedure;
16 /
Procedure created.
SQL>
SQL>
]]>