Return
-
Title
Running query gives ORA-00904 and Schema Browser show foreign characters -
Description
Executing a SQL query gives the error "ORA-00904: 'OBJECT_NAME': invalid identifier" and Schema Browser | Tables | Columns | shows foreign characters or symbols like Japanese or Chinese.
-
Cause
Using older Oracle Client, like 9.2.0.1, with Toad to connect to 10g or 11g database servers. -
Resolution
Please install a supported Oracle 10g or above client to run with Toad.
-
Additional Information
Here are the Oracle download pages for Oracle Client Software recommended: ***************************************** 32-bit Oracle 11g R2 Client: Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit) win32_11gR2_client.zip (684,581,290 bytes) http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html ***************************************** 64-bit Oracle 11g R2 Client: Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) win64_11gR2_client.zip (615,698,264 bytes) (cksum - 2947608743) http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html ***************************************** IMPORTANT NOTES: - During the Oracle Client installation, choose “ADMINISTRATOR” installation type (this is not automatically selected). - Download ‘directly’ to your “DESKTOP” location (and run it from there too). This can avoid many potential download and installation problems. - Un-Zip the downloaded file. Do not run the Oracle Setup from within the ZIP program or Zipped folder. - Ensure your Windows User has Administrator Rights before installing an Oracle Client (or Toad). - Toad for Oracle 11.5.1 and lower / SQL Navigator supports 32-bit Oracle Clients only. Do NOT use 64-bit Oracle Client. - The above 32-bit client will work on a 64-bit Windows OS’s. - Ensure you apply or copy over your TNSNAMES.ORA file (this file usually comes from your company). The default location for this file in 11g is: C:\app\\product\11.2.0\client_1\NETWORK\ADMIN\ NOTE: After installing the new client, ensure you select it in Toad’s / SQL Navigator’s login screen | under “Connect Using:” / “Oracle Home/Client:” (ensure you are NOT connected to any database for this setting to be available).