utl_http.request don't work
i try to request a webpage via utl_http.request (oracle 9.2.0.7).
when i connect to oracle via BEQ then it works!
when i try to connect with a normals TNSNAMES Connect via Listener than i get this error:
SQL> select name from V$database;
NAME
---------
VR
SQL> SELECT utl_http.request('http://www.oracle.com') FROM dual;
SELECT utl_http.request('http://www.oracle.com') FROM dual
*
FEHLER in Zeile 1:
ORA-29273: HTTP-Anforderung nicht erfolgreich
ORA-06512: in "SYS.UTL_HTTP", Zeile 1556
ORA-12570: TNS: Fehler beim Paket-Leser
ORA-06512: in Zeile 1
Any ideas ??
Thanx in advance,
Kai