<%@ page language="PL/SQL" %> <%@ page errorPage="Hrs_Error_Page.psp" %> <%@ plsql procedure="hotel_info_view" %> <%@ plsql parameter="p_req_type" type="VARCHAR2" %> <%! /** Overview : This PSP is part of the HRS application sample. The PSP displays the list of all the Hotels currently stored in the system. Modification History: Person Date Comments ------------------------------------------------------------- Srinivas Ramarao 09-AUG-2000 Initial Sample **/ /* Cursor to get details of all hotels */ CURSOR c_get_hotels IS SELECT id,name,address FROM hotels ORDER BY name; %>
<% /* Fetch all the Hotels in the database table and display them */ FOR l_hotel_rec IN c_get_hotels LOOP /* Display the details */ %> <% END LOOP; %>
Select Hotel Id   HotelAddress
  <%= l_hotel_rec.id %> <%=l_hotel_rec.name %> <%=l_hotel_rec.address %>