ODP.NET

Hi,

I am developing a C#/.NET 4.0 application that needs to retrieve data from an Oracle database 10g (10.2.0.4.0). We are using the instant client 11.2.

I have a very simple query that looks like that:

select distinct
round(s.field1, 5) as Field1,
p.field2 as Field2
from
tableA@dblink a
JOIN tableB@dblink b on a.id = b.d
where
a.filter1= :filter1
and a.filter2 = :filter2

From times to times (completely random), I have the following exception:
ORA-01460: unimplemented or unreasonable conversion requested
ORA-02063: preceding line from dblink

If I run the query in Toad directly then it works fine. So I am guessing the instant client must have a role in it?

To solve it, I can either wait (5min to 1h) or I can simply change my query by adding/removing a space somewhere:
select distinct
round ( s.field1 , 5 ) as Field1 ,
p.field2 as Field2
from
tableA@dblink a
JOIN tableB@dblink b on a.id = b.d
where
a.filter1= :filter1
and a.filter2 = :filter2

I tried to search for this exception but it really doesn't make any sense in my case (simple query, completely random, solved by adding/removing a space).
If you have ever experienced something similar or have any idea, please feel free to share!