| Doubt in pl/sql server pages [message #76385] |
Sun, 05 May 2002 23:16  |
satish kumar
Messages: 10
Registered: March 2002
|
Junior Member |
|
|
Hi,
I am working on HPUX 11.0 platform. I have a sample2.psp file whose contents look like
( removed all < & > for convience )
html
head
title DPSP Example 2/title
body
table width="100%"
% for r in (select * from all_users) loop %
tr
td %= r.username % /td
td %= r.user_id % /td
td %= r.created % /td
/tr
% end loop; %
/table
/body
/html
I executed the above file by saying
$ loadpsp -replace -user username/pwd sample2.psp
at the unix prompt.
A procedure by name sample2 was created in the oracle database.
Now, when i open this file sample2.psp on web browser,i am not able to see the contents of the file.
Please do let me know as to how to solve this. I need to see the contents of table all_users in the table format on the web.
Thanx in advance
Satish
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Doubt in pl/sql server pages [message #77112 is a reply to message #76385] |
Mon, 06 September 2004 21:35  |
dipankar maiti
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
Dear
write two tags on top of your .psp file
procedure name will be same as your .psp file name if
u have not renamed the file during loading in database
------------------------------
@% page language="PL/SQL" %
%@ plsql procedure="procedure name" %
-------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
