Discussion :

[squallJ]

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0

Bonjour,

Serait-il possible de me dire ou je peux trouver la manière de contacter un Web Service en PL/SQL?

Merci d'avance

[jmguiche]

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0

Bonjour,

Serait-il possible de me dire ou je peux trouver la manière de contacter un Web Service en PL/SQL?

Merci d'avance

Sans l'avoir jamais fais, je pense qu'en PL pur et dur, ce n'est pas possible.

En java ça l'est, et java est disponible dans le noyeau Oracle.
Et ce java peut être appelé de PL.

Donc : en java que tu apelles ensuite de PL.


Sauf s'il y a un package Oracle spécifique....


EDIT :

Clairement, il y a des trucs... Faut chercher. Cf la doc :

http://download.oracle.com/docs/cd/B....htm#sthref763

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.

[squallJ]

Ok merci à toi.