Getting "Syntax Error: Expecting identifier or quoted identifier." exception when trying to use DataAdapter.FillSchema() on an Oracle Database
Posted on 2009-05-08
I am working an a Visual Studio 2008 C# application connecting to an Oracle 10.2 database using built in .NET data object for Oracle.
My code as exists looks like:
When I run this code, I get the following exception: "Syntax Error: Expecting identifier or quoted identifier."
The SQL that is being run is: select * from (SELECT * FROM company) OracleTestSQL
This select works correctly when run directly against the database when using a tool like DBVisualizer.
The code also works perfectly, without generating any exception when I change it to the following:
Granted, I could just use that last bit of code, but for reasons of speed and latency, I want to only get the schema/data that I need, rather then alot of extra data.
Any help/suggestions would be greatly appreciated! Thanks in advance!