Skip to Main Content
  • Questions
  • ACL created but unable to fetch the result

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: April 09, 2018 - 12:23 pm UTC

Last updated: April 13, 2018 - 4:32 am UTC

Version: 11.2

Viewed 1000+ times

You Asked

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 ?

and Connor said...

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.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Usefill

A reader, June 20, 2018 - 10:05 am UTC

Thanks Connor McDonald

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library