Unable to run a cross query between MySQL and Oracle
说明
Unable to run a cross query between MySQL and Oracle. Having issues performing joins between MySQL and Oracle what is the best way to troubleshoot the problem?
原因
In this scenario, the Oracle client was 32 bit and Toad Data Point was 64 bit was installed on the same machine
解决办法
Make sure Toad Data Point and the database client installed are in the same bitness. For example 32 bit version of Toad Data Point and 32 bit Oracle client.