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(); } }
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)