Home » RDBMS Server » Server Administration » View PL/SQL server page running
View PL/SQL server page running [message #225870] Wed, 21 March 2007 15:43
Messages: 1
Registered: March 2007
Location: DR.
Junior Member


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.

<%@ 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;
<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.first_name %> </td>
<td> <%= emp_record.last_name %> </td>
<% END LOOP; %>

[Updated on: Wed, 21 March 2007 15:44]

Report message to a moderator

Previous Topic: Oracle 9i lock file (lkDBNAME)
Next Topic: create database
Goto Forum:

Current Time: Tue Feb 21 03:41:32 CST 2017

Total time taken to generate the page: 0.08059 seconds