tag:blogger.com,1999:blog-5215551487816981140.post5724980388290142175..comments2024-03-28T22:27:48.595-07:00Comments on ORA-00001: Unique constraint violated: Using the Slack webhook API from PL/SQLMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5215551487816981140.post-17004183071738944112018-02-22T04:47:33.842-08:002018-02-22T04:47:33.842-08:00@Edwin: Thanks for the feedback, those are some go...@Edwin: Thanks for the feedback, those are some good ideas! I went and read about the Commands API (https://api.slack.com/slash-commands) and as you point out, one can certainly use it to trigger various actions in the database and/or respond with information from the database.<br /><br />One could create a PL/SQL procedure with the parameters listed in the Commands API and expose it as a URL, or set up a handler using ORDS.<br /><br />That said, the actual implementation of such handlers would be quite application-specific, so I don't know how much of this belongs in a general-purpose utility library such as Alexandria.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-42899451816257982152018-02-21T14:09:26.828-08:002018-02-21T14:09:26.828-08:00Nicely packaged. Did you also look at building a s...Nicely packaged. Did you also look at building a slack-app that communicates with the database? It is quite easy to create an app in slack to implement slash-commands that call webservices, served by ORDS e.g.<br /><br />In this way, you can have two-way communication from slack with your database.<br /><br />E.g. I let people query some aspects of their Apex application trough their phone using Slack. <br /><br />It's such a nice platform Edwin van Meerendonkhttps://emoracle.wordpress.comnoreply@blogger.com