Solved

Calling web services from Oracle 10g database server

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now