test
v_recordcou
touterNUMBER
v_test
xmldomdom
ode
v_test_
odelistxmldomdom
odelist
v_test_
odectNUMBER
v_t
xmldomdom
ode
v_le

NUMBER
BEGIN
get_resp_clobp_xml_charp_ws_url
dbms_outputput_li
esubstrv_resp_clob1255
v_parserxmlparser
ewparser
xmlparserparseclobv_parserv_resp_clob
v_xmldocxmlparsergetdocume
tv_parser
7
f获得根元素v_subeleme
txmldomgetdocume
teleme
tv_xmldocv_
odeliststockxmldomgeteleme
tsbytag
amev_subeleme
tv_xml_bodyv_recordcou
touterxmldomgetle
gthv_
odeliststockdbms_outputput_li
ev_recordcou
touter
FORiIN0v_recordcou
touter1LOOP
v_test
xmldomitemv_
odeliststocki
v_test_
odelistxmldomgetchild
odes
v_test
v_test_
odectxmldomgetle
gthv_test_
odelist
FORjIN0v_test_
odectLOOP
v_txmldomitemv_test_
odelistj
v_le
le
gthxmldomgetprefixv_t
在这里如果直接将
ode的名字取出会有问题，会出java：，但是可以直接取出java：字符，所以截取java：
dbms_outputput_li
esubstrxmldomget
ode
amev_tv_le
2le
gthxmldomget
ode
amev_tv_le
1
dbms_outputput_li
exmldomget
odevaluexmldomgetfirstchildv_t
ENDLOOP
ENDLOOP
dbms_lobCLOSEv_resp_clob
END
24完整代码
8
f25结果
26调用代码declare
v_url
VARCHAR2500
soappacketVARCHAR24000
begi

dbms_outpute
able100000
这里的地址是wsdl地址去掉后面wsdl后的地址
v_urlhttplocalhost7001BSMtest
soappackete
vE
velopexml
se
v