Hello,
i have a function in a package that creates a table and copies into it all the entries from an existent table and then deletes it.
Sometimes this fails and then the data is in an inconsistent state where i have both tables and half entries in one and the rest in the other.
I haven't figured why and under which case this error occurs.
The question is, what is the best way to trace this and find the error?
I have checked DBMS_OUTPUT and TKPROF but neither seemed to work.
Is there any clear procedure on how this can be done?
I am on Windows 2008 Server with Oracle 11gR2.
Thank you in advance.