?
Solved

Calling web services from Oracle 10g database server

Posted on 2006-07-06
7
Medium Priority
?
1,542 Views
Last Modified: 2008-01-09
Hi,

Can anyone let me know in detail how to set up Oracle 10g database server to call a web service? I want a PL/SQL trigger to invoke one Java stored procedure (I don't want to use any built-in packages provided by Oracle) which in turn would call a web service hosted on a different machine possibly across firewall.

I tried it with some common tutorials available on the net, but those were mostly related to Oracle 9i and that doesn't work properly in Oracle 10g.

Let me know the details of any setup wihtout any 'obvious' assumptions.

My dev OS is winxp sp2. I've Oracle 10g release 2 installed.

-Thanks in advance.
0
Comment
Question by:rrmadhav
  • 3
5 Comments
 
LVL 19

Expert Comment

by:actonwang
ID: 17051915
did you try to use DBMS_DBWS to call web services?

see:

http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_dbws.htm#CHDIDGJH
0
 
LVL 19

Expert Comment

by:actonwang
ID: 17051925
sorry, it is UTL_DBWS pckage.
0
 
LVL 19

Accepted Solution

by:
actonwang earned 500 total points
ID: 17051935
0
 
LVL 16

Expert Comment

by:MohanKNair
ID: 17056028
See the following links about Oracle Java Stored Procedures

Oracle9i Java Stored Procedures Developer's Guide Release 2 (9.2)
http://www.lc.leidenuniv.nl/awcourse/oracle/java.920/a96659/toc.htm

Java, JDBC & Database Web Services
http://www.oracle.com/technology/tech/java/java_db/index.html

Oracle and Java Stored Procedures
http://www.developer.com/db/article.php/3337411
0
 

Author Comment

by:rrmadhav
ID: 17056328
will get back to you ppl after I test the answers/hints
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question