I am using a command like
).getclob () web_page
What does TNS have to do with HTTPURITYPE (which is really utl_tcp in a wrapper). I don't understand how TNS gets involved. It would seem to me that the implementation of utl_tcp which in written in C, would create the necessary socket etc. I understand how Oracle Net gets involved for inbound HTTP connections but for outbound connections it doesn't make any sense.
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1674
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.HTTPURITYPE", line 34
ORA-06512: at line 6
As a side note, the error takes 3 min 44 seconds before it happens. It should take 5 seconds to time out, because of the UTL_HTTP.set_transfer_time
out (5); command.
How can I ensure that control returns to my PL/SQL process after 5 seconds.