Querying a published Oracle table fails with an error "Cause: ORA-00933: SQL command not properly ended".
Article ID: KB0076519
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
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.
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.
Issue/Introduction
Querying a published Oracle table fails with an error "Cause: ORA-00933: SQL command not properly ended".
Environment
Windows and Linux
Resolution
Use the data source adapter version in TDV Studio corresponding with the back end Oracle database version. There should not be any conflict between the Oracle versions.
Feedback
Yes
No
Powered by
