Products | Versions |
---|---|
TIBCO Data Virtualization | All Supported Versions |
While querying published Oracle tables the below error is thrown by the TDV Studio:
Cause: ORA-00933: SQL command not properly ended
When the same table is executed from the Studio Scratchpad and the source, the result is returned successfully.
Root Cause:
The error occurs when there is a mismatch between the actual back end database version and the TDV Studio database adapter.
For example, if Oracle 12c is connected with TDV using the Oracle 11g(Thin Driver) data source adapter.