Return
-
Title
Error: "[Oracle][ODBC][Ora]Optional feature not implemented" when running a query. -
Description
When running the following query in the Cross Connection Query Editor while connecting to an Oracle database via ODBC:
Select DATETIME, PYMT, NODE, NAME
From PRIME
Where 1=1
And DATETIME >= '4-OCT-2012'
And NODE = 'RAC123'Receives the following error:
[Oracle][ODBC][Ora]Optional feature not implemented
=====
Another example query:
SELECTFROM_TZ(TO_TIMESTAMP(to_char(EFF_END_TMS, 'DD-MON-RR HH24:MI:SS'),'DD-MON-RR HH24:MI:SS'),'UTC') AT TIME ZONE 'America/New_York' AS CONVERTED_END_DATE FROMEMP_OWN.CAMPAIGN CAMPAIGNWHERECAMPAIGN.SRC_SYSTEM = 'EPP' -
Cause
ODBC Generic connection limitation.
-
Resolution
Connect using native Oracle Client software (TNS connection type) and try the query again.
-
Additional Information
The DATETIME will automatically be surrounded by single quote marks to work, i.e. 'DATETIME'.