Quoted string not properly terminated in oracle

Solution 1 will work, but I believe there is an underlying problem that usually is the cause of issues like this.
You shouldn't manually have to alter your data.
I'm guessing you are building your query something like this:

var query = "INSERT .... VALUES ('" + yourValue + "');

You should be using a paramaterized query which will take care of this and the potential sql injection attack that your database will be vulnerable to:

using (OracleCommand command = new OracleCommand("INSERT .... VALUES( :Name", connection))
{
   command.Parameters.Add(new OracleParameter("Name", dogName));
   // ... The rest of your code.
}

Kuthuparakkal

Even I had founded the solution in the same way, when the Value is been inserted into the database, I just used the inbuild function Replace available in asp.net

For Egs:

string nam="Frank D'Souza";
nam=nam.Replace("'","''");
now the inserted value would be
Frank D'Souza only in the DataBase..
not the Frank D''Souza .. :-)