Missing Comma, oracle ORA-00917
<p>I have this code for inserting values into a oracle database, and I get "Missing comma" Exception, and I can't see from where it comes.</p>

<pre><code> "insert into comandadvd values('" + txt_idComanda.Text + "','" +
                    txtFormat.Text + "','" + "', to_date('" + txtData.Text + "','DDMMYYY')'" + txtIdTipPlata.Text + "','" + txtPret.Text + "')";
</code></pre>

<p>Alse here it is the Oracle code for it:</p>

<pre><code>INSERT INTO ComandaDVD (Id_Comanda,Id_Format,Data_Comanda,Id_TipPlata,Pret)
VALUES ('1','1','12-11-2011','1','200');
</code></pre>

<p>Thanks in advance!</p>