9i to 10g, Datatype checking across database links
Hi All,
We've recently upgraded from 9i (9.2.0.5) to 10g (10.2.0.4) and have come across some changes in the behaviour of oracle. One of these is the implementation of datatype checking when selecting across database links. I was hoping that if I outline what's happening then someone would be able to confirm that this is now the case (maybe even provide a link to some documentation from oracle saying that these are the changes now in place?)
In 9i, we had a cursor performing a select similar to below:
SELECT some_columns
FROM owner.table_name@database_link
where ts_column = '0001-01-01-00.00.00';
0