Post status resolves in http request error 400

dashandwerknet · 2013-09-30T08:32:08.000Z

Hello,

i wrote a pl/sql package for sending tweets to my account with ‘https://api.twitter.com/1.1/statuses/update.json’.

a few weeks ago, everything was ok, but now i get an error while receiving the http.response.

Error is: ORA-29268: HTTP client error 400 - Bad Request

I am using oAuth and within oracle the wallet !

Thank you for help.

Regards

Frank

episod · 2013-09-30T14:28:30.000Z

What else have you tried to debug? Try taking a look at any response body or status message that comes with the HTTP 400 – maybe you’re not encoding some parameters correctly. Maybe there’s an issue with the account that you’re trying to post with.

dashandwerknet · 2013-09-30T20:02:00.000Z

Hello Taylor,

i have set UTL_HTTP.set_response_error_check (false); from true to false and got the full response from the twitter site.
It shows now {“errors”:[{“message”:“Bad Authentication data”,“code”:215}]}
but i have no idea what’s the reason.

Do you have any idea ?

episod · 2013-10-01T14:42:37.000Z

I’d take a look at how your OAuth request is formulated. This method has been more lenient with alternate encodings in the past but is relatively strict now. Some libraries get some minor things incorrect.