asp.net 向oracle数据库插入值错误

Question

            l_com = New OracleCommand("insert into city values(id,cityid,cityname,citytype,'admin','','')", l_con)            Dim l_id As OracleParameter = New OracleParameter("id", OracleType.Number)
            l_id.Direction = ParameterDirection.Input
            l_id.Value = System.DBNull.Value
            l_com.Parameters.Add(l_id)            Dim l_cityid As OracleParameter = New OracleParameter("cityid", OracleType.VarChar)
            l_cityid.Direction = ParameterDirection.Input
            l_cityid.Value = l_dt.Rows.Item(i).Item("code")
            l_com.Parameters.Add(l_cityid)            Dim l_cityname As OracleParameter = New OracleParameter("cityname", OracleType.VarChar)
            l_cityname.Direction = ParameterDirection.Input
            l_cityname.Value = l_dt.Rows.Item(i).Item("name")
            l_com.Parameters.Add(l_cityname)            Dim l_citytype As OracleParameter = New OracleParameter("citytype", OracleType.Number)
            l_citytype.Direction = ParameterDirection.Input
            If i < 34 Then
                l_citytype.Value = 0
            ElseIf i > 33 Then
                l_citytype.Value = 1
            ElseIf i > 375 Then
                l_citytype.Value = 2
            End If
            l_com.Parameters.Add(l_citytype)            l_com.ExecuteNonQuery()其中id为在数据库中写的触发器实现自增的变量，city表的字段为ID INTEGER
CITYID VARCHAR2(32)
CITYNAME N VARCHAR2(30)
CITYTYPE N NUMBER
OPERATOR N VARCHAR2(50)
OPERDATE N DATE
REMARK VARCHAR2(50)
谁能帮忙看看，为什么每次插入的时候都告诉我变量类型或者数量错误

Answer 1

自己检查下，测试的时候，打开局部变量，看看变量的赋值在插入过程中的赋值情况，检查SQL语句，看表的非空字段和插入的数据量是否存在冲突