Calling web services from Oracle 10g database server
Posted on 2006-07-06
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.