Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » plsql web toolkit (10g express edition)
plsql web toolkit [message #296102] Thu, 24 January 2008 10:37 Go to next message
futi
Messages: 22
Registered: November 2007
Junior Member
I heard many things about this toolkit. But i can't run it.
I'm using 10g Express Edition. And i want to create an html page via plsql.

I was creating a procedure that includes htp and htf methods. There is no problem. I know too much html. I am compiling that procedure, it was compiled, there wouldn any error. But, nothing is happened. Only, procedure is compiled errorless.

Likely, i must the install plsql web toolkit and i specify the folder where my html pages are.

I heard, i can run myhtml page with : ' http://localhost:portnumber/pls/DAD/SYS.procedurename

what is the pls, what is the DAD, how can i configure these, and what is the port number? 8080, or 7777, 7778 which one?

i tried http://localhost:8080/ , there is ORACLE LICENSE AGREEMENT and this page not includes any link to direct.

and i cant find dads.conf file oraclehome/apache/...
i can't do anything.

how can i see my html output?
thanx you.
Re: plsql web toolkit [message #298071 is a reply to message #296102] Mon, 04 February 2008 23:04 Go to previous message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

Hi,
DAD means 'data Access descriptor'. DAD allowa the webserver to connect to the database when a specific URL is requested.
By default 'Oracle 10g Express Edition' is comming with its Apex DAD. for designing your own DAD, you need to configure it. Yor can create DAD with the help of 'DBMS_EPG' package.
STEPS :
1. Create dad.
2. Set DAD attributes.
3. Put authorization.
Create a procedure in authorized schema(suppose new_proc).
Call procedure in browser:

http://127.0.0.1:8080/<new_dad_name>/<procedure_name>

Please read orafaq page http://www.orafaq.com/faqmodpl.htm.
Previous Topic: Reorder/resequence rows in a report
Next Topic: Getting number of hits in a report
Goto Forum:
  


Current Time: Thu Mar 28 21:35:07 CDT 2024