Tool for monitoring SQL query results needed

Question

Hi,

I am looking for a tool to monitor results of a periodically run sql query and raise a notification based on the fact that the query returns any results. (any other filters are welcome)

I need to watch a transaction table for errors, and it would be great if my sql query could run in background, refresh itself periodically and show a notification when there are any results.

I need to connect to Oracle DB and I currently use PL/SQL Developer or Oracle SQL Developer.

Free, OS and lightweight solutions preferred :)

UPDATE:

Preferably I would like to not create/modify any database objects. We would like to use this on our clients databases too and not all of them have license to modify the DBs where their Oracle Apps run.

Thank you in advance

Answer 1

Put the query in a stored procedure. Have your monitoring / notification code there.

Answer 2

How about using DBMS_Scheduler to run a stored procedure that queries the table and then uses UTL_Mail to send an email in case of a problem?