OraFAQ Forum: WebCenter Suite & Portal » Doubt in Pl/Sql Server Pages using Oracle WebDB2.2

Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Doubt in Pl/Sql Server Pages using Oracle WebDB2.2

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Doubt in Pl/Sql Server Pages using Oracle WebDB2.2 [message #76362]

Tue, 02 April 2002 02:38

Chandra Sekhar
Messages: 4
Registered: April 2002

Junior Member

Anybody please help me.

I am a student of computer science.
I installed Oracle 8i on my PC and then Oracle WebDB2.2
Now I want to create PL/Sql Server Pages.

I am able to connect to Port 80,
Administer the Users n Roles.

When I write a procedure at SQL Prompt containing
objects of HTP package such as HTP.PRINT etc the procedure gets created.

But
I am not able to understand as how to get it viewed thru the browser.

Also I used notepad to write a HTML page n then saved it with extension .PSP.
Then I came to SQL PROMPT and typed

Sql> load psp -replace scott/tiger <file-name>;

It says
Invalid Sql statement.

Why is it so?

Regards
Chandra Sekhar

Report message to a moderator

Re: Doubt in Pl/Sql Server Pages using Oracle WebDB2.2 [message #76363 is a reply to message #76362]

Tue, 02 April 2002 02:58

Ardian B. Santoso
Messages: 11
Registered: April 2002

Junior Member

Try this :
http://server:port/dadname/procedure

sql> load psp -replace scott/tiger ;
you must do this command not in the SQL prompt but
at DOS Prompt ,

example : c:load psp -replace scott/tiger ;

Good Luck

Report message to a moderator

Re: Doubt in Pl/Sql Server Pages using Oracle WebDB2.2 [message #76421 is a reply to message #76362]

Mon, 17 June 2002 20:38

randal singh
Messages: 1
Registered: June 2002

Junior Member

1.how to configure DAD
2.WHETHER YOU REQUIRE WEBDB.IF SO HOW TO CONFIGURE IT
OR YOU REQUIRE A ANOTHER CD FOR WEBDB
3.THE MAIN IS I WANT TO HAVE A PAGEBREAK AFTER EVERY 44 LINES.CAN YOU TELL ME HOW TO DO IT.IT IS ACCORDING TO THE PRINTER.

Report message to a moderator

Re: Doubt in Pl/Sql Server Pages using Oracle WebDB2.2 [message #76978 is a reply to message #76362]

Mon, 03 May 2004 09:19

Mark Hollingsworth
Messages: 1
Registered: May 2004

Junior Member

From reading your message it doesn't look like you have completed all the steps required to display the page within a browser.
You need to set up a Data Access Descriptor (DAD) from the mod_PLSQL link from the administration page.

You will give the DAD a name along with connect string information.

To connect to your page the URL will look similar to this;
http://localhost/pls/dad_name/procedure_name/.

Report message to a moderator

Re: suggest books name on psp [message #77041 is a reply to message #76978]

Fri, 16 July 2004 22:04

sameer sharma
Messages: 1
Registered: July 2004

Junior Member

please suggest some books name on psp with proper syntax used and send some small applications in psp

Report message to a moderator

Previous Topic:	MOD_PLSQL Configure
Next Topic:	Please Any one tell me , how I get Developer patch

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 18:44:46 CST 2025