Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » web application with plsql
web application with plsql [message #76343] Tue, 19 March 2002 03:18 Go to next message
RamP
Messages: 2
Registered: March 2002
Junior Member
Hi
I could not able to call a procedure from browser. I am using oracle 8.1.7(with apache 1.3) on win 2000.
1) In wdbsvr.app I made the following changes
...
[[DAD_simpledad]]
connect_string = localhost:1521:ORCL
password = tiger
username = scott
default_page = mydad
...

2) The TNS file is
KUMAR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = a5p70d166ur4o2e)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = kumar.ad)
)
)

3) The following URL is used to call the procedure:

http://localhost:8000/pls/mydad/helloworld

I will appreciate if anybody gives detailed steps
to call procedures from browser

Thanks

Ram
Re: web application with plsql [message #76353 is a reply to message #76343] Mon, 01 April 2002 19:25 Go to previous messageGo to next message
Ardian B. Santoso
Messages: 11
Registered: April 2002
Junior Member
Have you configure PL/SQL with utility link example :
http://theproject/pls/portal30/admin_/gateway.htm
Re: web application with plsql [message #76358 is a reply to message #76343] Mon, 01 April 2002 21:20 Go to previous messageGo to next message
RamP
Messages: 2
Registered: March 2002
Junior Member
no, I didn't. Where Should I configure it. Please
explain all the steps to call the procedure.

Ram
Re: web application with plsql [message #76360 is a reply to message #76343] Tue, 02 April 2002 00:05 Go to previous message
Ardian B. Santoso
Messages: 11
Registered: April 2002
Junior Member
Try to following step :
1. Create connect string to your database
even local.
2. go to http://server:port/pls/admin_/gateway.htm
3. Set the default gateway (try to use simpledad)
4. Setting the simpledad , fill the name/password and
connect string created.
5. Test
sql> create or replace procedure hello as
begin
htp.print('Hello World');
end;

6. call from web browser
http://server:port/pls/simpledad/hello

7. Good Luck
Previous Topic: Re: Oracle Forms over the internet
Next Topic: need help with updating HTML frames at once
Goto Forum:
  


Current Time: Sun Sep 27 22:31:46 CDT 2020