Hi,
Oracle Standard Edition 11.2.0.1 running on 64bit windows 2008 R2
I am getting this in my aplication at the moment, if I drop and recreate the procedure it then moves to the next procedure called in my app .... ie. there is something fundamentally wrong with the database!!
ORA-04045: errors during recompilation/revalidation of <procedure>
ORA-01405: fetched column value is NULL
There are no other errors in my alert log
Could it be a user has been dropped when they shouldn't? SYS and SYSTEM are both still there .... is there a script I can run to check?
Any other ideas?
Thanks
Robert