|
I rant as I
run
Better than SOAP with PL/SQL, why not use a simple restful call to an
app server?
SET serveroutput
ON SIZE 40000
SET DEFINE OFF
DECLARE
req utl_http.req;
resp
utl_http.resp;
value
VARCHAR2(1024);
BEGIN
req :=
utl_http.begin_request('http://localhost:8080/myapp/myfun?transactionKey=LKJD9IE933JKLJ¶m=hellworld');
utl_http.set_header(req,
'User-Agent', 'Mozilla/4.0');
resp := utl_http.get_response(req);
LOOP
utl_http.read_line(resp,
value, TRUE);
dbms_output.put_line(value);
END LOOP;
utl_http.end_response(resp);
EXCEPTION
WHEN
utl_http.end_of_body THEN
utl_http.end_response(resp);
END;
/
|
![[*]](../images/dailyLinkIcon.gif){kind=small}
