Click here to Skip to main content
15,886,806 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am inserting record in Oracle table using ODP.NET Oracle.DataAccess.Client throug Asp.net c#.
The oracle table is tblGroup and GROUPNAME varchar2,GROUPDETAILS varchar2 is column name
but data is not inserting.I am using following code
C#
public void insertRecord(string StudentgroupName, string groupDetails) 
{
    using (OracleConnection con = GetConnection())
    {
        OracleCommand cmd = new OracleCommand();
        cmd.Connection = con; //assigning connection to command
        cmd.CommandType = CommandType.Text; //representing type of command
        cmd.CommandText = "INSERT INTO tblGroup (GROUPNAME,GROUPDETAILS) values(@GROUPNAME,@GROUPDETAILS)";

        //adding parameters with value
        cmd.Parameters.Add("@GROUPNAME", StudentgroupName);
        cmd.Parameters.Add("@GROUPDETAILS", groupDetails);
        
        con.Open(); //opening connection
        cmd.ExecuteNonQuery();             
    }
}

and got following error
Quote:
Oracle.DataAccess.Client.OracleException ORA-00936: missing expression at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at SchoolsManagementSystem.DAL.insertRecord(String StudentgroupName, String groupDetails) in d:\c#\SchoolsManagementSystem\SchoolsManagementSystem\App_Code\DAL.cs:line 85 at SchoolsManagementSystem.Group.btnSubmit_Click(Object sender, EventArgs e) in d:\c#\SchoolsManagementSystem\SchoolsManagementSystem\Group.aspx.cs:line 26

Guide me How can I solve my problem
Posted
Updated 30-Jun-14 17:54pm
v3

You should use cmd.Parameters.AddWithValue. If you want to just use Add refer to http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracledataadapter.insertcommand(v=vs.110).aspx[^]
 
Share this answer
 
Comments
Jörgen Andersson 30-Jun-14 18:07pm    
No he shouldn't. System.Data.OracleClient is deprecated and should not be recommended.
Change "@" in the commandtext to ":".
Remove the @ in the parameters.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900