| View PL/SQL server page running [message #225870] |
Wed, 21 March 2007 15:43 |
alanrd
Messages: 1
Registered: March 2007
Location: DR.
|
Junior Member |
|
|
Hi.
I have created a pl/sql server page, my example is the code below.
I compile this code with
loadpsp -replace -user hr/hr test.psp
My question is: how i can run the show_employees procedure from an http url?
I have instaled Oracle10g XE. My URL of the database web page is http://localhost:8080/apex/ but i can't read the test.psp page from anywhere. I am so confused of what i need to do here to put the .psp file running.
Thanks for any help you can give me.
| Quote: | <%@ 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 first_name, last_name
FROM employees
ORDER BY first_name;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html">
<title>List of Employees</title>
</head>
<body TEXT="#000000" BGCOLOR="#FFFFFF">
<h1>List of Employees</h1>
<table width="40%" border="1">
<tr>
<th align="left">Last Name</th>
<th align="left">First Name</th>
</tr>
<% FOR emp_record IN emp_cursor LOOP %>
<tr>
<td> <%= emp_record.first_name %> </td>
<td> <%= emp_record.last_name %> </td>
</tr>
<% END LOOP; %>
</table>
</body>
</html>
|
[Updated on: Wed, 21 March 2007 15:44] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
