All geek questions in one place

Oracle: receiving notifications when a table receives new data

In psql, we have PL / Perl to communicate with an external program when a new row is inserted into our table. As in any case (procedural language) for communication with an external program in Oracle. To achieve this, what should I do .....?

Can someone help me solve this problem .....

+3
source share
3 answers

Oracle offers packages for external communication with a file or pipe. Create a trigger to write to one of them when updating a row. Be careful how you handle errors in this code so as not to lock the database or roll back a transaction if an external program is not available. Check out the utl packages.

+3
source

The most appropriate answer to your rather vague question depends on what problem you want to solve when you mention communication with external programs.

+3
source

, Oracle, .

+2

Source: https://habr.com/ru/post/1745234/

More articles:


All Articles