SQL & PL/SQL

Does anyone know if there is a way to determine if there are any pending changes on a transaction?

We are on Oracle 8.6.1, but upgrading to 9.2 in the next month or so.

I have no need to know the details of any pending changes, just a boolean - Are there any or not?

I have a client program and I wish to implement something on a timer. This timer code should only run if there have been no inserts, updates, or deletes performed since the last rollback or commit because the code will do a commit.

I tried coding it in stored procedures that use autonymous transactions and it worked fine in testing, but when put into higher volume use in production the corporate DBAs told me that their error logs were filling up with strange system errors.

The errors went away when we took the code out.

This was months ago and I am just getting back to it now and the error logs are gone so I can't tell you what they were.

Thanks for any help,
Chris Elvart
SBC