Solved

Calling web services from Oracle 10g database server

Posted on 2006-07-06
7
1,504 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

Title # Comments Views Activity
clob to char in oracle 3 96
Oracle collections 15 39
ER Diagram 3 42
Email query results in HTML 6 38
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ā€¦
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

730 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