Hello
I am using Oracle ODBC gateway (version 11.2.0.1.0) to connect to an Intersystems Cache database. I can successfully execute a query of the kind below
select * from remote_table@cachedb
However, issuing
select * from all_tables@cachedb returns the following error
>
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Cache ODBC][State : S0002][Native Code 30]
[libcacheodbc.so]
[SQLCODE: <-30>:<Table or View not found>]
[Cache Error: <<SYNTAX>errdone+2^%qaqqt>]
[Details: <Prepare>]
[%msg: < SQL ERROR #30: Table 'SQLUSER.ALL_TABLES' not found>] {S0002,NativeErr = 30}
ORA-02063: preceding 7 lines from XXX
>
Obviously, there is no table named 'all_tables' at the remote database. I was under the impression that the 'dg4ODBC' executable would appropriately translate a query against 'all_tables','all_objects' etc into the ODBC equivalent for querying the database catalog.
How is one supposed to query the catalog at the remote database ?
Varad