Dear All,
We have a problem in our application. Entries are getting deleted from a table when they should not.
It is still a mystery what is deleting them as we could not find any DELETE references in the pl/sql objects we have - like procedures, functions, packages, triggers etc.
I did a select from v$sqlarea and found a DELETE statement there:
delete from table1 where prid=:1
Any thoughts on how I can determine the query source i.e. where this query is originating from ?
I do not have access to trace files.
Thanks in advance.