Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Doubt in Pl/Sql Server Pages using Oracle WebDB2.2
Doubt in Pl/Sql Server Pages using Oracle WebDB2.2 [message #76362] Tue, 02 April 2002 02:38 Go to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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/.
Re: suggest books name on psp [message #77041 is a reply to message #76978] Fri, 16 July 2004 22:04 Go to previous message
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
Previous Topic: MOD_PLSQL Configure
Next Topic: Please Any one tell me , how I get Developer patch
Goto Forum:
  


Current Time: Fri Jan 24 17:16:56 CST 2020