1 Reply Latest reply on Oct 30, 2012 10:34 AM by Jim Smith

    execute the show_employees procedure through a URL

      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