Unable To Get List Of Tabs From An Excel File Via Odbc 11g (Dg4odbc) (Doc ID 1085946.1)

Last updated on APRIL 19, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms


Selecting user_tables from a MS Excel sheet fails although Windows Patch 20 containing the Excel fixes is applied.

select tabl_ename from user_tables@<db_link>

ORA-00604: une erreur s'est produite au niveau SQL r�cursif 1
ORA-44004: nom SQL qualifi� non valide
ORA-06512: � "SYS.HS$_DDTF_SQLTABLES", ligne 58
ORA-06512: � ligne 1

Changes

Upgraded database from 10.2 to 11.1

- using a newly created database using dbca works.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms