HTTP request case for Oracle

The IVR of an old system needs to be connected to another company. People can only provide HTTP interfaces, but I can only use SQL interfaces, so I cannot use SQL to connect to HTTP.

Use Cases are as follows. Please provide more valuable comments.

-- Created on 2012-1-2 by yamzef in Wuxi
Declare
I integer; -- local variables here
Urlp varchar2 (2000 );
REQ utl_http.req;
Resp utl_http.resp;
Value varchar2 (2000 );
Begin
Urlp: = 'HTTP: // 110.10.10.90: 8001/SMIs/servlet/ogret ';
Req: = utl_http.begin_request (urlp );
Resp: = utl_http.get_response (req );
Loop
Utl_http.read_line (resp, value, true );
Dbms_output.put_line ('webreply '| value );
End loop;
Utl_http.end_response (RESP );
Exception
When utl_http.end_of_body then
Utl_http.end_response (RESP );
End;

-- End --