View Single Post
  #1 (permalink)  
Old November 29th, 2004, 07:32 PM
andy_study andy_study is offline
Registered User
 
Join Date: Nov 2004
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 16 - Oracle Client - BindingExample

[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.