What's net got do with it

[Michael Moore]

 
I am using a command like

   UTL_HTTP.set_transfer_timeout (5);

   SELECT HTTPURITYPE.createuri
             (   'http://fluffy.sf.nowhere.net:8080/rodger-admin/manageCacheFull.do?userName='
              || 'myuser&password=password&action=update&cacheName=com.rcom.tarcaptu'
              || 're.prxcommon.entity.RTotal&cacheKey=9'
             ).getclob () web_page
     INTO l_web_page
     FROM DUAL;

My question is NOT how to fix the problem. Instead, what I want to know is what TNS has 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 about 4 minutes  before it happens.  It should take  5 seconds to time out, but I believe that  the 5 second time out only works  at the the  HTTP level, but  because the problem is TNS related,  the TNS  time-out interval will need to lapse before the error message is dumped.

Mike

[Erik Ykema]

I suggest posting this at comp.database.oracle.server.
Did you also look up the exact error messages for ORA-29273 and
ORA-12535? And disd you search metalink?
Regards,
Erik

On Jan 28, 11:24 pm, "Michael Moore" <michaeljmo...@gmail.com> wrote:
> I am using a command like
>
> UTL_HTTP.set_transfer_timeout (5);
>
> SELECT HTTPURITYPE.createuri

> ( 'http://fluffy.sf.nowhere.net:8080/rodger-admin/manageCacheFull.do?use...
> || 'myuser&password=password&action=update&cacheName=
> com.rcom.tarcaptu'

[Michael Moore]

Erik,
Thanks for the hints. I did look up the error messages but the description seemed very generic and really didn't give me a clue about the mechanics behind it all. I will post to comp.database.oracle.server and I will have our DBA's search metalink.

Regards,
Mike