Hi TEam,
I have created function to return the different language by refrencing
http://www.orafaq.com/forum/t/170320 also i have created ACL and after running the function we have below error.
select eospb_translation ('cats', 'fr','en') from dual;
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1819
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.HTTPURITYPE", line 34
ORA-06512: at "XXXXXXX.EOSPB_TRANSLATION", line 14
ORA-06512: at line 1
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.
could you please help on this ?
If it was an ACL error, you would "Access Denied". You are getting: TNS:operation timed out
This means we could not reach the target - we were blocked by (for example) a firewall.
Speak to your network guys - they might need to open up access. Don't forget that the request is coming from your database server not your local machine.