Hi All-

I've been trying to get read the friends timeline using Oracle PL/
SQL's UTL_HTTP method but for some reason it throws a "HTTP client 400
- Bad Request" message at line #19 - line with the get_response()
function. This piece of code works perfectly well for others. I'm
using Oracle XE. Could you please help?

DECLARE
http_req utl_http.req;
http_resp utl_http.resp;
t_update_send VARCHAR2(200);
res_value VARCHAR2(4000);
XML_RETURN CLOB;
BEGIN
t_update_send := '--head';
http_req := utl_http.begin_request('http://twitter.com/statuses/
friends_timeline.xml',   'POST',   utl_http.http_version_1_1);
utl_http.set_response_error_check(TRUE);
utl_http.set_detailed_excp_support(TRUE);
utl_http.set_body_charset(http_req,   'UTF-8');
utl_http.set_header(http_req,   'User-Agent',   'Mozilla/4.0');
utl_http.set_header(http_req,   'Content-Type',   'application/x-www-
form-urlencoded');
utl_http.set_header(http_req,   'Content-Length',
to_char(LENGTH(t_update_send)));
utl_http.set_transfer_timeout(to_char('60'));
utl_http.set_authentication(http_req,   'nitin_pai',   'qwerty77',
'Basic');
utl_http.write_text(http_req, t_update_send);
http_resp := utl_http.get_response(http_req);

BEGIN
WHILE 1 = 1
LOOP
 utl_http.read_line(http_resp,   res_value,   TRUE);
 dbms_output.put_line(res_value);
 XML_RETURN := XML_RETURN || res_value;
END LOOP;
EXCEPTION
WHEN utl_http.end_of_body THEN
NULL;
END;

utl_http.end_response(http_resp);
END;


Thanks for your help!

-Nitin

PS: This code is sourced from http://apextoday.blogspot.com/search/label/Twitter


-- 
To unsubscribe, reply using "remove me" as the subject.

Reply via email to