Solved

Calling web services from Oracle 10g database server

Posted on 2006-07-06
7
1,499 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
7 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 125 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

856 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