Problem with GetSchemaTable

[stofel]

Hi, I have a problem with a sql-Statement. I’m developing an application in which a user can type in a sql-statement, e.g. "Select * from (select name from employee)" . This statement is not very reasonable but it is syntactically correct. My code is OracleCommand cmd = new OracleCommand("Select * from (select name from employee)", myOracleConnection); OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.KeyInfo); System.Data.DataTable colinfo = rdr.GetSchemaTable(); At this staement the application crashed with an exception: "InvalidOperationException: Identifier expected or identifier in quotes expected" . (The message is in germaan: "Syntaxfehler: Erwartet wird ein Bezeichner bzw. Bezeichner in Anführungszeichen.", but i try to tranlate it in english) I want to use GetSchemaTable to get all the columninformation I needed to display the result. So how can I solve the problem ? Thanks in advances Willibert

[andyharman]

Does it work if you specify a table alias:   Select * from (select name from employee) **a** That should make the SQL legal.

[stofel]

Hi, Select * from (select name from employee) is a legal statement, OracleClient and Toad could execute it. I could by-pass it, I change OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.KeyInfo); into OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.SchemaOnly); But their I don't get the basistablename even in a normal select. Tanks Willibert