SET serveroutput ON SIZE 40000 DECLARE# J; ?; h# X4 {0 g% E7 ?
v_text varchar2(100) := '试验%S已ok';--不能有空白
% P; c) Q5 D4 J5 N6 M4 a E# p req utl_http.req;
; W/ P+ W" d1 f7 y' p resp utl_http.resp;6 Y0 C$ P" x& i/ _5 p
value VARCHAR2(1000);0 n% u$ K7 Y1 c, C- E+ q4 i
BEGIN! j$ |# c# \9 H% n4 O4 }& r
v_text := replace(v_text,'%','%25');" X- p$ Q6 z7 L1 U# a9 ]
v_text := replace(utl_encode.text_encode(v_text), '=', '%');
! R" y# t2 D1 l* D1 m: Y5 g req := utl_http.begin_request('http://ajax.googleapis.com/ajax/services/language/translate?v=1.0&q=' ||
5 T, g) q/ M$ M; P/ o! @. n v_text || '&langpair=zh|en');+ O" u" x3 N; e
resp := utl_http.get_response(req);" ~5 p$ b" K7 O7 k* e9 r# c
LOOP/ }3 M" _1 |8 _$ T" s
utl_http.read_line(resp, value, TRUE);4 u, [' W- V" q6 y2 B/ j
value := replace(value,'% S','%S');( j3 \$ j3 @( s8 e( m& E
value := replace(value,'{"responseData": {"translatedText":"','');) ~% w4 J) b9 G. o
value := replace(value,'"}, "responseDetails": null, "responseStatus": 200}','');
1 \0 Z+ u9 H3 M4 |5 Y dbms_output.put_line(value);. z$ L: v& Y8 ? D J
END LOOP;( Q3 V; t4 q# ]8 ?
utl_http.end_response(resp);% F4 `* g! Q( J7 r8 \
EXCEPTION6 f; U9 ?0 ?; X. K6 e6 b5 ~" b
WHEN utl_http.end_of_body THEN- F) ~1 B# z' @; W! k
utl_http.end_response(resp);
8 y4 F' D T4 e; n4 i4 k END; |