= "INSERT INTO jobRequest(reqNo,userID,reqType,projTitle,dept,d_section,unit,author,targetDate, " _
& "reqStat,location,approvalNo,evalRem,itscRem,evaltoitscRem,dateSubmit) " _
& "VALUES(:reqNo,:userID,:reqType,:projTitle,:dept,:d_section,:unit,:author,:targetDate, " _
& ":reqStat,:location,:approvalNo,:evalRem,:itscRem,:evaltoitscRem,:dateSubmit)"
reqCmd.Parameters.Add("reqNo", OracleType.Number, 5, 1)
reqCmd.Parameters.Add("userID", OracleType.VarChar, 50, "chico")
reqCmd.Parameters.Add("reqType", OracleType.Number, 1, 1)
reqCmd.Parameters.Add("projTitle", OracleType.VarChar, 100, "comsat")
reqCmd.Parameters.Add("dept", OracleType.VarChar, 50, "mis")
reqCmd.Parameters.Add("d_section", OracleType.VarChar, 50, "web development")
reqCmd.Parameters.Add("unit", OracleType.VarChar, 50, "development")
reqCmd.Parameters.Add("author", OracleType.VarChar, 50, "onats")
reqCmd.Parameters.Add("targetDate", OracleType.DateTime, 11, "15-Sep-1975")
reqCmd.Parameters.Add("reqStat", OracleType.Number, 1, 3)
reqCmd.Parameters.Add("location", OracleType.Number, 1, 1)
reqCmd.Parameters.Add("approvalNo", OracleType.VarChar, 50, "ok")
reqCmd.Parameters.Add("evalRem", OracleType.VarChar, 1000, "ok")
reqCmd.Parameters.Add("itscRem", OracleType.VarChar, 1000, "ok")
reqCmd.Parameters.Add("evaltoitscRem", OracleType.VarChar, 1000, "ok")
reqCmd.Parameters.Add("dateSubmit", OracleType.DateTime, 11, "15-Sep-1975")
reqCmd.ExecuteNonQuery()
conn.Close()
what's wrong? please help me. im new to .net with oracle implementation.
thanks.