ORA-00936: Expression not found

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
fredericopc
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Wed, 17 Sep 2014 9:01 am

Select all

 
 using (var cnx = new OleDbConnection(new AdministradorDAO().conexao)) 
            { 
                var sql = 
                    @"insert into usuarios(matricula, nome, senha, nivel, maleta, email)  
                    values (:matricula, :nome, :senha, :nivel, :maleta, :email)"; 
                               
                using (var cmd = new OleDbCommand(sql, cnx)) 
                { 
                    cnx.Open(); 
 
                    cmd.Parameters.AddWithValue("matricula", txt_matricula.Text); 
                    cmd.Parameters.AddWithValue("nome", txt_nome.Text); 
                    cmd.Parameters.AddWithValue("senha", txt_senha.Text); 
                    cmd.Parameters.AddWithValue("nivel", DropDownList_nivel.Text); 
                    cmd.Parameters.AddWithValue("maleta", txt_maleta.Text); 
                    cmd.Parameters.AddWithValue("email", txt_email.Text); 
 
                    try 
                    { 
                        cmd.ExecuteNonQuery(); 
                    } 
                    catch (Exception) 
                    { 
                        throw; 
                    } 
                    finally 
                    { 
                        if (cnx.State == ConnectionState.Open) cnx.Close(); 
                    } 
                } 
            } 
 
When doing the insert directly on the bank, it adds perfectly. Could anyone help me?

Select all

insert into actweb.usuarios (matricula, nome, senha, nivel, maleta, email) values ('TESTE', 'Frederico', 'TESTE', 1, 7000, 'daerror@error.com.br'); 
User avatar
dr_gori
Moderador
Moderador
Posts: 5026
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Have I seen if the expression being mounted actually generates this SQL command?
This error usually occurs when Query is incomplete.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest