Notifications from ADW to OCI via PLSQL

Another post on the most awesome PLSQL SDK for OCI within the Oracle Autonomous Databases. How can I do this or that after this PLSQL/SQL is complete? How can I get an email? How can I run some other code and so on and so on… It’s possible to trigger this from within the database itself and publish a message to OCI notification.

It’s easy with a little code of course, here’s a snippet, the title and notification body are hard-coded here for illustration…

I already have a topic created that I will use in the example, I have subscribed to the topic using email.

I can now call this from PLSQL;

Upon completion the notification message is published to OCI Notification service and an email arrives in my inbox. Easy!

You can find out more information on the PLSQL SDK for OCI below;

The example is very simple yet powerful to do some simple events, this example used an email subscription but could be any of OCI’s subscription types.



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
David Allan

Architect at @Oracle developing cloud services for data. Connect on Twitter @i_m_dave