web提交到oracle乱码问题,utl_http发送请求报文获取其他系统web service，解析返回报文时，中文出现转义乱码...

本帖最后由 b1uepanda 于 2018-4-19 09:44 编辑

declare

l_soap_request_raw raw(32767);

v_value VARCHAR2(32767);

v_clob_content CLOB;

v_blob_content blob;

l_soap_respond VARCHAR2(32767);

l_soap_content VARCHAR2(30000);

l_soap_request VARCHAR2(30000);

l_soap_request_CLOB CLOB;

begin

l_soap_content := '

WECHAT

01110041

1

2016-11-21

10:01:50

0000000000011111111

WC001

100025532008

]]>

';

-- service's input parameters

l_soap_request := l_soap_content;

-- preparing Request...

l_http_req := utl_http.begin_request(l_wsdl

,'POST'

,sys.utl_http.http_version_1_1);

--设置协议保持连接状态

Utl_Http.Set_Persistent_Conn_Support(l_http_req, TRUE);

-- ...set header's attributes   设置编码