ODBC -- call failed. [Oracle][ODBC][ORA-00932: inconsistent datatypes:expected %s got %s (#932) (1 Viewer)

mansied

Member
Local time
Today, 03:24
Joined
Oct 15, 2020
Messages
99
Hello
I have a table in oracle and I linked it to my access. then I can open it and see data.
I created a simple query to see records with the criteria "del" in one field, the below error comes up when I run the query !!!!
Could you help me with what would be this issue?


ODBC -- call failed.
[Oracle][ODBC][ORA-00932: inconsistent datatypes:expected %s got %s (#932)
 

Isaac

Lifelong Learner
Local time
Today, 00:24
Joined
Mar 14, 2017
Messages
8,738
Can you post your sql?
 

bastanu

AWF VIP
Local time
Today, 00:24
Joined
Apr 13, 2010
Messages
1,401
Check your Oracle data types for compatibility with Access, might need to create a view to convert if you cannot modify the table itself.
Cheers,
 

Users who are viewing this thread

Top Bottom