Odbc Driver Errors - OPR4ONWY:U9IM8TAC:OI2DL65P
609043Oct 19 2009 — edited Oct 19 2009
A materialized view was imported from the database without any apparent errors. Import was after the Oracle client was installed.
But, I am receiving Odbc driver error when using the admin tool to view data in a specific materialized view or when using answers to query data in the same materialized view:
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 923, message: ORA-00923: FROM keyword not found where expected at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
Oracle Odbc client is 10.2.0.1 and Oracle Database Server is 22.214.171.124. Odbc connection was created after the install of the Oracle client.
Materialized view has some columns calculated/derived from the base tables. These columns in the materialized view have been cast to specific datatypes.
I have granted select to the Odbc connection. And, I created a private synonym for the Odbc connection.
Materialized view can be queried without any problem from Sqlplus 10.2 or Toad 9.7 using the same connection as Odbc.
Odbc connection can be used to view data in other tables, views or materialized views without any problem.
Any recommendation on resolving issues with the Odbc definition of this materialized view?