Those useful and interesting technology snippets that I keep forgetting to write down until I need them again.
Wednesday, 14 October 2015
Oracle and ODBC
For some reason on Oracle 12 at least I having trouble getting the ODBC call SQLColumns to work . I was using it as an existance test for a database table, and Oracle kept returning 942 (table does not exist) even though the table was owned by the schema associated with the user that was being used in the ODBC call.
It turned out that the user needed the SELECT ANY DICTIONARY system privilege. Not sure why, but granting that to the user allowed me to make the call successfully.
Subscribe to:
Posts (Atom)