We are attempting to use Navicat 8 for Oracle, to export data from our Oracle 9i database.
When choosing to "Open Table" from the context menu on certain tables in our schema, we receive an error, "ORA-00932: inconsistent datatypes: expected %s got %s". For other tables, Open Table works perfectly.
As we are not trying to insert or update any data, the recommended actions on http://ora-00932.ora-code.com/
do not seem to apply.
We get the same error in the message log when attempting a "Data Transfer" task on the problematic tables.
We are using the latest version of Navicat for Oracle, v8.2.18 standard edition, on a Windows 2000 Pro box (SP4), although same error occurs under Windows XP Pro SP3.
Version of Oracle DBMS is 184.108.40.206.0 (Windows Edition, running on Win2K Advanced Server Sp4) - we suspect the DBMS version may be too old and needs to be patched.
The only thing remotely exceptional about the problem table is that it contains some varchar2 columns with length > 255 characters.
The issue has already been submitted to Navicat tech support who are looking at it, however has anyone experienced this before - any ideas?
Thanks in advance.