Hi,
I would like to use the UTL_HTTP functionality in Oracle Database XE to make a REST call out to the Twitter API and be able to post twitter messages.
I have found a couple of blog posts covering this topic, however they appear to be out of date as the Twitter API now uses OAuth which is not covered in these articles:
Twitter Meets Oracle: ORA_Tweet
Ora_Tweet – Tweet From Oracle, A PL/SQL Twitter API | Database Geek Blog
This is the service that I think I need to call.
https://dev.twitter.com/rest/reference/post/statuses/update
I've generated the relevant consumer keys and secrets on the twitter dev website but I can't really find any examples to implement the authentication in PL/SQL. Most of the Orcale documentation regarding OAuth I think is geared towards being the provider of the service rather than the consumer.
Is anyone able to post any useful resources or exampes for ♦invoking a REST service with OAuth from Oracle Database?
Thanks for reading!