ORA-01461 Error

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

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s