?
Solved

Calling web services from Oracle 10g database server

Posted on 2006-07-06
7
Medium Priority
?
1,523 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
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.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to recover a database from a user managed backup
Suggested Courses

777 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