This discussion is archived
1 Reply Latest reply: Oct 30, 2012 3:34 AM by Jim Smith RSS

execute the show_employees procedure through a URL

829510 Newbie
Currently Being Moderated
Hey! All

I have created simple.psp file:=>

<%@ page language="PL/SQL" %>
<%@ page contentType="text/html" %>
<%@ plsql procedure="show_employees" %>
<%-- This example displays the last name and first name of every
employee in the hr.employees table. --%>
CURSOR emp_cursor IS
SELECT last_name, first_name
FROM hr.employees
ORDER BY last_name;
<meta http-equiv="Content-Type" content="text/html">
<title>List of Employees</title>
<body TEXT="#000000" BGCOLOR="#FFFFFF">
<h1>List of Employees</h1>
<table width="40%" border="1">
<th align="left">Last Name</th>
<th align="left">First Name</th>
<% FOR emp_record IN emp_cursor LOOP %>
<td> <%= emp_record.last_name %> </td>
<td> <%= emp_record.first_name %> </td>
<% END LOOP; %>

2. D:\>loadpsp -replace -user hr/hr E:\OracleBestPractices\OraclePLSQL\simple.psp
"E:\OracleBestPractices\OraclePLSQL\simple.psp": procedure "show_employees" crea

3.Browser users can execute the show_employees procedure through a URL.But how? Please guide me .

Thanks in Advance


  • Correct Answers - 10 points
  • Helpful Answers - 5 points