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

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

python - GRASS parser() error -

Swift game error message -