Hi I'm having issues running a query from a custom application through my work.
I'm making an ODBC connection directly to my Oracle database.
Here is my connection string (this works just fine):
DRIVER={Oracle in OraDb11g_home2};server=<server>;UID=<username>;PWD=<password>;
Query:
SELECT AUDIT_TYPE, EXTENDED_TIMESTAMP, STATEMENT_TYPE, RETURNCODE,AUDIT_OPTION, PRIV_USED, OS_USER FROM SYS.DBA_COMMON_AUDIT_TRAIL WHERE ROWNUM <= 10
Everytime I try to connect and run this query I get the Error:
ERROR [HYC00][Oracle][ODBC][Ora]Optional feature not implemented....
The thing is when I run this query from SQL Plus it executes just fine.
Does anyone have any suggestions?