[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 ORA-00911 Invalid Character
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

ORA-00911 Invalid Character.


Applies to: SQL Server 2008 R2 Standard Edition, Oracle 12i.
 

Problem Description.
 

While trying to query a table on SQL Server via an Oracle DBLINK, we received the following error.






The query was constructed on the following way:


Select * from _tablename@dblinkname otc;

It seems the two leading underscore characters on the table name were the cause of the errors.


Workaround
 

The workaround was to use double quotes for wrapping the table name and the DBLINK name,


Select * from "_tablename"@"dblinkname" otc;




 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.