plsql调用ebservice.docVIP

PLSQL调用WEBSERVICE 王凡 woshiwangfan@ wf141732@ 2009-9-20 一般方法utl_dbms 目前网上使用最多的是使用UTL_DBWS包。 准备工作 下载需要用到的jar包 ? 10G之前: /technology/sample_code/tech/java/jsp/dbwscallout-utility.zip ? 10G: /technology/sample_code/tech/java/jsp/dbwscallout-utility-10R2.zip ? 10G 和 11I: /technology/sample_code/tech/java/jsp/dbwscallout-utility-10131.zip 下载后解压出两个包 加载jar包 查看下系统的java class 数量 SELECT owner, status, COUNT(*) FROM dba_objects WHERE object_type = JAVA CLASS GROUP BY owner, status; 我的数据库为 Win的话，使用如下命令行 loadjava -u sys/wangfan -r -v -f -genmissing -s -grant public F:\dbws-callout-utility-10R2\sqlj\lib\dbwsa.jar F:\dbws-callout-utility-10R2\sqlj\lib\dbwsclient.jar 这个过程会持续一段时间。 权限授予 对需要调用的用户授予权限，也可以再loadjava的时候换成需要的用户 execute dbms_java.grant_permission(schema,SYS:java.util.PropertyPermission,xySet,write); execute dbms_java.grant_permission(schema,SYS:java.util.PropertyPermission,xyHost, write); execute dbms_java.grant_permission(schema,SYS:java.util.PropertyPermission,xyPort, write); execute dbms_java.grant_permission(schema,SYS:java.lang.RuntimePermission, accessClassInPackage.sun.util.calendar,); execute dbms_java.grant_permission(schema,SYS:java.lang.RuntimePermission,getClassLoader,); execute dbms_java.grant_permission(schema,SYS:.SocketPermission,*,connect,resolve); execute dbms_java.grant_permission(schema,SYS:java.util.PropertyPermission,*,read,write); execute dbms_java.grant_permission(schema,SYS:java.lang.RuntimePermission,setFactory,); 调用代码实现 DECLARE l_service utl_dbws.service; l_call utl_dbws.CALL; l_result anydata; l_wsdl_url VARCHAR2(1024); l_service_name VARCHAR2(200); l_operation_name VARCHAR2(200); string_type_qname sys.utl_dbws.QNAME; l_input_params utl_dbws.anydata_list; BEGIN l_wsdl_url := http://localhost:7001/BSM/BsmPickReleaseIfaceService?WSDL; l_service_name := BsmPickReleaseIfaceServiceService; l_operation_name := hello; l_service := utl_dbws.create_service(wsdl_document_locati