OraFAQ Forum: Weblogic & Application Server » web application with plsql

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » web application with plsql

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

web application with plsql [message #76343]

Tue, 19 March 2002 03:18

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

Report message to a moderator

Re: web application with plsql [message #76353 is a reply to message #76343]

Mon, 01 April 2002 19:25

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

Report message to a moderator

Re: web application with plsql [message #76358 is a reply to message #76343]

Mon, 01 April 2002 21:20

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

Report message to a moderator

Re: web application with plsql [message #76360 is a reply to message #76343]

Tue, 02 April 2002 00:05

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

Report message to a moderator

Previous Topic:	Re: Oracle Forms over the internet
Next Topic:	need help with updating HTML frames at once

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 01:56:34 CST 2024