Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Doubt in pl/sql server pages
Doubt in pl/sql server pages [message #76385] Sun, 05 May 2002 23:16 Go to next message
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 #76395 is a reply to message #76385] Wed, 22 May 2002 01:58 Go to previous messageGo to next message
Shankar Lakkaraju
Messages: 7
Registered: May 2002
Junior Member
Hi Satish,

Could you send me the error message you got when trying to execute the procedure through your browser.

yours truly

Shankar Lakkaraju.
Re: Doubt in pl/sql server pages [message #76437 is a reply to message #76385] Mon, 01 July 2002 01:37 Go to previous messageGo to next message
Sebastian
Messages: 10
Registered: July 2002
Junior Member
Have you granted the sample2 procedure to public ?
Re: Doubt in pl/sql server pages [message #76460 is a reply to message #76385] Tue, 23 July 2002 02:38 Go to previous messageGo to next message
jigar
Messages: 74
Registered: July 2002
Member
hello,

if the cursor don't fetch any data then

it is possible that "no page display".
parameter passing in pl/sql server pages [message #76933 is a reply to message #76385] Thu, 25 March 2004 01:29 Go to previous messageGo to next message
puja goyal
Messages: 1
Registered: March 2004
Junior Member
sir,
i want to know how to pass variables values which is run time entered by the user in pl/sql server pages
Re: Doubt in pl/sql server pages [message #77112 is a reply to message #76385] Mon, 06 September 2004 21:35 Go to previous message
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" %

-------------------------------------------------
Previous Topic: Web based Deployment
Next Topic: 9iAS services Very Urgent!
Goto Forum:
  


Current Time: Sun Sep 27 02:53:58 CDT 2020