SET serveroutput ON SIZE 40000 DECLARE1 H" d" z! R" [) `1 m% q
v_text varchar2(100) := '试验%S已ok';--不能有空白
! C- A# R7 E& @$ `% [7 @ req utl_http.req;$ H* @, c0 L2 ^/ P
resp utl_http.resp;! d3 w" q) I# l4 g2 g* D0 l
value VARCHAR2(1000);
! }" X- w y6 j) D' J- X+ m BEGIN8 [& c7 q1 ]/ v3 @3 N
v_text := replace(v_text,'%','%25');2 t6 s/ }" n( I3 O: j1 |, z
v_text := replace(utl_encode.text_encode(v_text), '=', '%');
- o( T' Y1 w6 ~; y. S* Q1 ^; h req := utl_http.begin_request('http://ajax.googleapis.com/ajax/services/language/translate?v=1.0&q=' ||
" W5 m8 h. z/ n/ j/ _, O v_text || '&langpair=zh|en');' `6 |* e( o# l+ Y0 @
resp := utl_http.get_response(req);0 f2 |+ g# t- `8 ~ r7 {$ p, a; L
LOOP' ~, G( ^" ]( s
utl_http.read_line(resp, value, TRUE);4 l9 s4 T- l6 T+ P7 Q$ q9 C- A
value := replace(value,'% S','%S');2 l0 {- c- f+ l$ Y
value := replace(value,'{"responseData": {"translatedText":"','');3 J& d, M6 p3 o( D
value := replace(value,'"}, "responseDetails": null, "responseStatus": 200}','');
5 M/ t- z3 A9 B5 X dbms_output.put_line(value);6 t5 E# o# T; e
END LOOP;
! U$ d9 U, ?' m5 S; ?6 ? utl_http.end_response(resp);
, o8 Q/ `( J1 M9 ]" ^ EXCEPTION
9 K6 D) p8 V2 u+ b }, Q, I WHEN utl_http.end_of_body THEN2 Q; M2 w. [# i0 j% n9 C
utl_http.end_response(resp);# S% f+ f* `2 k8 j0 S. W% ~
END; |