PL/SQL (MOSC)

MOSC Banner

utl_http.request don't work

edited Apr 7, 2010 4:24AM in PL/SQL (MOSC) 5 commentsAnswered
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center