Oracle INSERT giving error in C#

Question

DbCommand command = new OracleCommand(
       "insert into hardware (HardwareID) VALUES (6);", myConnection);
command.ExecuteNonQuery();

Hardware is a NUMBER(7, 0).

I am trying to make this simple Oracle INSERT work using C#. However, I keep getting an 911 error saying that there is an invalid character.

What am I doing wrong?

I can execute the following code without problems:

DbCommand command2 = new OracleCommand("Select * from Hardware", myConnection);
command2.ExecuteReader();

(I plan on using parameters later, I am just trying to get a proof-of-concept built)

Timothy Carter · Accepted Answer · 2009-07-29 21:06:12Z

2

I believe you can't add the ';' at the end. So try:

DbCommand command = new OracleCommand(
       "insert into hardware (HardwareID) VALUES (6)", myConnection);
command.ExecuteNonQuery();

answered Jul 29, 2009 at 21:06

Timothy Carter

15.8k7 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

I believe Good Charlotte put it best: "Its the little things, the little things, that always bring you down. Thanks! :D

sheesh - that was my first thought, but I tossed that out thinking: nah, it can't be that obvious and simple :-(