UTL_DBWS - Webservices

Download do arquivo dbws-callout-utility-10131.zip

cd $ORACLE_HOME/sqlj/lib

loadjava -u sys/password -r -v -f -genmissing -s -grant public dbwsclientws.jar dbwsclientdb11.jar


execute dbms_java.grant_permission('','SYS:java.util.PropertyPermission','http.proxySet','write'); 
execute dbms_java.grant_permission('','SYS:java.util.PropertyPermission','http.proxyHost', 'write'); 
execute dbms_java.grant_permission('','SYS:java.util.PropertyPermission','http.proxyPort', 'write'); 
execute dbms_java.grant_permission('','SYS:java.lang.RuntimePermission', 'accessClassInPackage.sun.util.calendar',''); 
execute dbms_java.grant_permission('','SYS:java.lang.RuntimePermission','getClassLoader',''); 
execute dbms_java.grant_permission('','SYS:java.net.SocketPermission','*','connect,resolve'); 
execute dbms_java.grant_permission('','SYS:java.util.PropertyPermission','*','read,write'); 
execute dbms_java.grant_permission('','SYS:java.lang.RuntimePermission','setFactory','');

Exemplos de utilização podem ser vistos em:

How to Verify the Installation of UTL_DBWS Package in Oracle Database 11g (Doc ID 1166206.1)

Using UTL_DBWS to Make a Database 11g Callout to a Document Style Web Service (Doc ID 841183.1)

UTL_DBWS - Consuming Web Services in Oracle 10g