bank_request为字段名称是xml如下:
<responseblock version="3.67">
<requestreference>W58-0YTpAh47</requestreference>
<response type="SCHEMEUPDATE">
<billing>
<payment type="VISA">
<issuer>WELLS FARGO BANK NATIONAL ASSOCIATION</issuer>
<issuercountry>US</issuercountry>
<pan>414718######8413</pan>
</payment>
</billing>
<error>
select extractvalue(bank_request, '/responseblock/response/billing/payment/issuer') AS name from xxx ;
输出:WELLS FARGO BANK NATIONAL ASSOCIATION
select extractvalue(bank_request, '/responseblock/response/billing/payment/@type') as card_type from xxx;
输出:VISA