Oracle Database Discussions

Hi All,

We have a unique situation in production for one of our applications.

There is a “ora 01426 numeric overflow” error occurring for any DML that is happening in any of the tables. The application was working very fine till today morning and there were no changes done in the code or the way the application is being used by the users.

Below is the version of db:-

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

Does anybody have any idea of the above situation. My guess would be to restart the database. But please let me know if anyone has encountered this error any time.


Also I am adding some more information retrieved from Trace File. Below Error log is just an example of one table where Insert/Update tried to take place. These type of error happening for every table as told in the previous post.

ORA-01426: numeric overflow ORA-06512: at "ADM.DT_FinRecord_T", line 183 ORA-04088: error during execution of trigger 'ADM.DT_FIN_T' ORA-06512: at "ADM.journal_voucher_P", line 241 ORA-06512: at line 1 Error: ORA 1426 Text: numeric overflow


Above mentioned ADM.journal_voucher_P is the package of ADM schema where insert in FinRecord table is taking place. ADM.DT_FinRecord_T is the trigger which is being used for logging purpose.



Any help will be appreciated..

Thanks in advance..!!!

Roy

Edited by: ROY on Sep 28, 2012 10:58 PM