I have an application where I am capturing few values in a form and I am trying to save them in Database at the same time I want to trigger a rest post request with those attributes . How to achieve this in oracle apex ? Should I write a db trigger for this ?
Yes this is possible. Put the code in a page process with same condition as your row processing. To invoke a rest request via pl/sql you can use apex_web_service.make_rest_request
, documented here
db triggers could be a solution but should be avoided in my opinion. Supposed you create an on-update trigger that fires the rest request and then a DBA comes a long and runs an update statement that affects all rows but forgets to disable the trigger... that means that this rest request will be re-executed for every single row... .