tags:

views:

526

answers:

1
Q: 

Does Oracle Applications API expose Web Services? (i.e. WS-* SOAP Web Services?)

I see Oracle has a comprehensive Integration Repository online (http://irep.oracle.com/).

Question is... how can one call these procedures? Do I have to do it through PL/SQL? Or do all these functions/procedures have corresponding web services exposed automatically?

A: 

Oracle is moving to SOA big time with tools and infrastructure support for BPEL, WebServices and ESB. Some parts of Oracle EBS already have web services api, others will surely follow in the future.

Here's some documentation on how to integrate peoplesoft crm with oracle ebs: http://www.oracle.com/technology/pub/articles/bpel_cookbook/pravin.html

Andrej  2009-01-05 11:50:42
Thanks for the reply. From your response I gather that only some, not all, API functions are exposed as web services.Do you know if it is possible to call all the API functions/procedures using ODP.NET? (I'm worried about 'Concurrent Programs' and 'Open Interface Tables', not sure what they are).
willem  2009-01-05 11:59:42
Concurrent manager (oracle's batch scheduler) has a plsql api, so you should be able to use it from odp.net.
Andrej  2009-01-06 10:29:00

related questions

Is there a Way to use Linq to Oracle
NHibernate and Oracle connect through Windows Authenication
Boolean Field in Oracle
How do you manage schema upgrades to a production database?
How do I deal with quotes ' in SQL
When do you use table clusters?
Oracle write to file
MS SQL Server 2008 "linked server" to Oracle : schema not showing
Develop on local Oracle instance
Resources for an Oracle beginner
What strategies have you employed to improve web application performance?
Automate Syncing Oracle Tables With MySQL Tables
Best way to encapsulate complex Oracle PL/SQL cursor logic as a view?
What Content Management does your workplace use?
What is the difference between oracle's 'yy' and 'rr' date mask?
SQL/Query tools?
How to make Pro*C cope with #warning directives?
Oracle SQL Developer not responsive when trying to view tables (or suggest an Oracle Mac client)
How big would such a database be?
Oracle - What TNS Names file am I using?
What is a good way to open large files across a WAN?
How do I find the high water mark (for sessions) on Oracle 9i
SQL Case Statement Syntax?
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?