Hello everyone.

Is there any way (system perspective) to find out if a statement modifies
any table?
Let's say I want to invoke some stored procedure. I don't know
(when someone else wrote it) if it changes any table in the database.

Is there any counter in any system perspective or any other mean in
Oracle to find out that after some action performed on the database, any
table has changed it's state? This "counter" shouldn't change if there was
no change (only select statement was used).

Any thougts are welcome.
Best regards
Pablo

private address: pastulap at poczta dot onet dot pl