oracle - C# {"ORA-00917: missing comma"} INSERT QUERY ERROR -
i trying insert these values:
int limit = 50000; int acc_id = 1; string query = "insert current_account(c-account_no,daily_limit) values ('"+acc_id+"','"+limit+"')"; oraclecommand command = new oraclecommand(query, con); command.executenonquery(); but getting missing comma exception:
c# {"ora-00917: missing comma"}
are sure current_account table contains column name c-account_no? column named c_account_no (with dash - replaced underscore _) instead?
if column name genuinely contain dash, wrap column name in double-quotes:
string query = "insert current_account(\"c-account_no\",daily_limit) " + // ...
Comments
Post a Comment