PLSQL调用WEBSERVICE
王凡woshiwa
gfa
gmailcomwf141732sohucom
2009920
1一般方法utl_dbms
目前网上使用最多的是使用UTL_DBWS包。11准备工作下载需要用到的jar包10G之前httpdow
loadoraclecomtech
ologysample_codetechjavajspdbwscalloututilityzip10Ghttpdow
loadoraclecomtech
ologysample_codetechjavajspdbwscalloututility10R2zip10G和11Ihttpdow
loadoraclecomtech
ologysample_codetechjavajspdbwscalloututility10131zip下载后解压出两个包
f12加载jar包查看下系统的javaclass数量SELECTow
erstatusCOUNTFROMdba_objectsWHEREobject_typeJAVACLASSGROUPBYow
erstatus
我的数据库为10102Wi
的话，使用如下命令行loadjavausyswa
gfa
rvfge
missi
gsgra
tpublicFdbwscalloututility10R2sqljlibdbwsajarFdbwscalloututility10R2sqljlibdbwsclie
tjar
这个过程会持续一段时间。
2
f13权限授予对需要调用的用户授予权限，也可以再loadjava的时候换成需要的用户
executedbms_javagra
t_permissio
schemaSYSjavautilPropertyPermissio
httpproxySetwrite
executedbms_javagra
t_permissio
schemaSYSjavautilPropertyPermissio
httpproxyHostwrite
executedbms_javagra
t_permissio
schemaSYSjavautilPropertyPermissio
httpproxyPortwrite
executedbms_javagra
t_permissio
schemaSYSjavala
gRu
timePermissio
accessClassI
Packagesu
utilcale
dar
executedbms_javagra
t_permissio
schemaSYSjavala
gRu
timePermissio
getClassLoader
executedbms_javagra
t_permissio
schemaSYSjava
etSocketPermissio
co
ectresolve
executedbms_javagra
t_permissio
schemaSYSjavautilPropertyPermissio
readwrite
executedbms_javagra
t_permissio
schemaSYSjavala
gRu
timePermissio
setFactory
14调用代码实现DECLARE
3
fl_serviceutl_dbwsservice
l_call
utl_dbwsCALL
l_resulta
ydata
l_wsdl_urlVARCHAR21024
l_service_
ameVARCHAR2200
l_operatio
_
ameVARCHAR2200
stri
g_type_q
amesysutl_dbwsQNAME
l_i
put_paramsutl_dbwsa
ydata_list
BEGIN
l_wsdl_urlhttplocalhost7001BSMBsmPickReleaseIfaceServiceWSDL
l_service_
ameBsmPickReleaseIfaceServiceService
l_operatio
_
amehello
l_serviceutl_dbwscreate_servicewsdl_docume
t_locatio
urifactorygeturil_wsdl_url
service_
ame
l_service_
ame
l_callutl_dbwscreate_callservice_ha
dlel_serviceport_
ameNULLoperatio
_
amel_operatio
_
ame
stri
g_type_q
amesysutl_dbwsto_q
amehttpwwww3org2001XMLSchemastri
g
sysutl_dbwsadd_parameterl_call
amestri
g_type_q
ameParameterModeIN
sysutl_dbwsset_retur
_typel_callstri
g_type_q
ameutl_dbwsadd_parameterl_call
amestri
g_type_q
ameParameterModeIN
l_i
put_params1a
ydataco
vertvarchar212
l_resultr