ORA-00911: invalid character

Question

I create two tables in my oracle database (11g) as follows:

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

Then there is a problem in my C # program:

  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(); 

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

Answer 1

Delete (with a comma) from the end of the SQL string

Answer 2

In case other people come here to learn how to include several statements in one command, you need to wrap your instructions in begin and end . This will stop incorrect character errors due to half-columns. For example:

 var command = new OracleCommand(@" begin select * from test; select * from test2; end;") 

Answer 3

Why are you using a semicolon in a query ... This is simply perceived as an invalid character ..... You must remove the semicolon (;) from the query and do it like this:

  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(); 

Read more about this error here .

Answer 4

This is not this guy's problem, but hopefully this helps someone:

I often have this problem with single quotes hidden inside inline comments, for example:

 select foo from bar where /* some helpful comment with a "can't" or somesuch */ baz='qux' 

The unrivaled single quote in the commentary evokes all kinds of drama, and the oracle does not go out of its way to help you understand this.

Answer 5

Replace the sqldatasource parameter ? to :Column_name in the delete , update and insert commands.