<div>
<div class="content wysiwyg-content">
I am the beginer to the PSP(PLSQL Server Pages),I created a sample psp procedure &quot;first&quot; 
 
&lt;% page LANGUAGE=&quot;PL/SQL&quot; %&gt; 
&lt;% plsql PROCEDURE=&quot;first&quot; %&gt; 
&lt;HTML&gt; 
&lt;HEAD&gt;&lt;TITLE&gt;This is a PSP Page &lt;/TITLE&gt;&lt;/HEAD&gt; 
&lt;BODY&gt; 
 
This is a list of employees:&lt;BR&gt; 
&lt;% FOR emp IN (SELECT * FROM emp) %&gt; 
Employee ID = &lt;%= emp.empno %&gt; 
Employee NAME = &lt;%= emp.ename %&gt; &lt;BR&gt; 
&lt;% END LOOP; %&gt; 
&lt;/BODY&gt; 
&lt;/HTML&gt; 
 
I have loaded this procedure into Database using loadpsp. 
To access from the Internet explorer , 
I have to create PL/SQL Gateway through a Web Listener. 
How do I create Web listener in Oracle 9i database (not in oracle 9iAS)?
</div>
</div>

I am the beginer to the PSP(PLSQL Server Pages),I created a sample psp procedure "first"

<% page LANGUAGE="PL/SQL" %>
<% plsql PROCEDURE="first" %>
<HTML>
<HEAD><TITLE>This is a PSP Page </TITLE></HEAD>
<BODY>

This is a list of employees: 
<% FOR emp IN (SELECT * FROM emp) %>
Employee ID = <%= emp.empno %>
Employee NAME = <%= emp.ename %> 
<% END LOOP; %>
</BODY>
</HTML>

I have loaded this procedure into Database using loadpsp.
To access from the Internet explorer ,
I have to create PL/SQL Gateway through a Web Listener.
How do I create Web listener in Oracle 9i database (not in oracle 9iAS)?

How do I create Web listener in Oracle 9i database (not in oracle 9iAS)?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.