ORA-00911：无效字符 [英] ORA-00911: invalid character

问题描述

我在甲骨文创建两个表（11克）数据库是这样的：

I create two table in my oracle (11g) database like this:

    create table "test" ("id" int);
    create table test ("id" int);

然后在我的C＃程序存在问题：

Then in my C# program there is a problem :

    OracleConnection conn = new OracleConnection(-myConnectionString-);
    conn.Open();
    OracleCommand command = new OracleCommand("select * from test;", conn);
    var v = command.ExecuteReader(); 
    OracleCommand command = new OracleCommand("select * from \"test\";", conn);
    var v = command.ExecuteReader(); 

为Command.ExecuteReader却（）我有一个ORA-00911：无效字符错误

for both command.ExecuteReader() I have an "ORA-00911: invalid character" error.

推荐答案

删除;从SQL字符串的结尾（分号）

Remove ; (semi-colon) from the end of SQL string

这篇关于ORA-00911：无效字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！