Calling web services from Oracle 10g database server


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.
Who is Participating?
actonwangConnect With a Mentor Commented:
did you try to use DBMS_DBWS to call web services?

sorry, it is UTL_DBWS pckage.
See the following links about Oracle Java Stored Procedures

Oracle9i Java Stored Procedures Developer's Guide Release 2 (9.2)

Java, JDBC & Database Web Services

Oracle and Java Stored Procedures
rrmadhavAuthor Commented:
will get back to you ppl after I test the answers/hints
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.