Hi Team,
Could any one suggest pl/sql script to convert the data from english to Polish in Oracle apps R12.
Please let me know.
I have tried below but Iam getting errors, can you please suggest good and working approach.
declare
txt varchar2(100);
tlum varchar2(2000);
begin
txt:=utl_url.escape('Kura przeszla przez ulice');
tlum := regexp_substr(httpuritype ('http://translate.google.com/translate_a/t?client=t&text='||txt||'&hl=en&sl=pl').getclob(),'"(.*?)"',1,1,null,1);
dbms_output.put_line(tlum);
end;
ORA-29273: HTTP request failed
ORA-29268: HTTP client error 400 - Bad Request
ORA-06512: at "SYS.HTTPURITYPE", line 38
ORA-06512: at line 6
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
Fix the error and retry the HTTP request.