[u]Chapter 16 - Oracle Client - BindingExample</u>

I am not able to add new records using the following Insert sql statements when importing the System.Data.OracleClient Namespace:

  objCommand.CommandText = "INSERT INTO titles " & _
            "(title_id, title, type, price, pubdate) " & _
            "VALUES(:title_id,:title,:type,:price,:pubdate );" & _
            "INSERT INTO titleauthor (au_id, title_id) VALUES
            (:au_id,:title_id)"

An Oracle exception is reported, "ORA-00911: invalid character". The error appears to be as result of the ";". I am currently updating the Oracle database by removing the ";" and executing the INSERT SQL's individually.

A solution to this problem will be highly appreciated.

Thanks.

Andy,

It seems that although Oracle requires a semicolon in its syntax in views and stored procedures, it is no valid in the OracleCommand object. You need to remove the semicolon at the end of your insert statement. This also means that you’ll only be able to execute one insert statement at a time.

Thearon