Intermittent ORA-1460 or ORA-1461 Accessing Database Link Using Bind Variables with ODP.NET
Last updated on APRIL 13, 2017
Applies to:Oracle Data Provider for .NET - Version 10.2.0.1.0 to 184.108.40.206.20
Microsoft Windows (32-bit)
***Checked for relevance on 14-Apr-2017***
There are two errors associated with this issue:
- ORA-1460 error may occur when a query with a bind variable is executed that uses a Database Link. The query may execute successfully for sometime until the size of the bind variable exceeds the size of the first execution. This issue is very similar to the one described in <Note 567142.1> which deals with a bug that is specific to anonymous blocks.
- ORA-1461 error is much more difficult to replicate but appears to be related to <Note 6828981.8>.
This issue is triggered by the fix to <Bug 6828981> which is in numerous RDBMS Patches beginning in 10.2.0.3. After applying this bug fix it is possible to get ORA-1460 and ORA-1461 errors using a database link from an application that previously worked.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms