SQL Query Web Services
Middle-tier applications, desktop applications, and tools can search, retrieve, and extract business data (relational, XML, text, or spatial) from the database using Web Services mechanisms. As a result, you can implement data-bound services, such as predefined warehousing queries, catalog search queries, and Map/GIS services, and expose them to other applications by reusing predefined SQL queries.
Web Services Data Source
This feature renders the output resulting from external Web Services calls as regular SQL output, which can then be used in the FROM clause of a SQL query. SQL functions can be applied to WHERE clauses before returning the query results. This conversion of external Web Services into SQL data sources is a building block of enterprise data integration.
Enhanced PL/SQL Web Services
This feature improves PL/SQL Web Services by supporting BOOLEAN, CLOB, BLOB, and PL/SQL types, enabling you to use most of your existing PL/SQL packages as Web Services.
Consuming External Web Services from SQL and PL/SQL
Any SQL-enabled tool or application can transparently and easily consume dynamic data from external web services.
Partager