Last morning, when I arrived work, reviweing the alerts and errors I have seen the next error in a Oracle 10.2.0.3;
Errors in file /app/oracle/database/util/financ/prod/bdump/fipo_smon_14161.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01461: can bind a LONG value only for insert into a LONG column
Like the error give me not too information about which is the problem I consulted MOS (formaly Metalink). It reference the Bug 6085625. In this case after read the note isn’t very clearly if there is a workaround avaliable, it mentions a pair of workaround that can help in some cases, the only solution is apply patch (upgrade to 10.2.0.4).
Many times I talked about perform an upgrade because a bug, it is so hardly and most times impossible to upgrade in a short time. Normally upgrade needs lots of probes, applications test from development teams and so on. In this case I’ll live with this error for a some months until I can upgrade this database.
HTH – Antonio NAVARRO