找不出错的点，总是报ORA-00911: invalid character，为什么？

Question

Dim orclconn As OracleConnection = New OracleConnection(strconn)
orclconn.Open()

Dim sql As String = "SELECT count(*) FROM SHAYIN_JYOHO WHERE SHAYIN_ID=? AND SHAYIN_PASSWORD=?"
Dim cmd As OracleCommand = New OracleCommand(sql, orclconn)
cmd.Parameters.Add("@SHAYIN_ID", OracleDbType.Int32).Value = Convert.ToInt32(id)
cmd.Parameters.Add("@SHAYIN_PASSWORD", OracleDbType.Varchar2, 32).Value = pass

Dim count As Integer

Try
count = cmd.ExecuteNonQuery()

Catch ex As Exception

End Try

If count > 0 Then

flag = True

Else

flag = False

End If

login = flag

找不出错，总是报ORA-00911: invalid character

Answer 1

Dim OraSession As Object '会话对象Dim OraDatabase As Object '数据库对象Dim OraDynaset As Object'动态集对象Dim OraDatabase As Object’字段集对象Set OraSession =CreateObject("OracleInProcServer.XOraSession")Set OraDatabase=OraSession.CreateDatabase("Demo","scott/tiger",0&)'建立数据库连接Set OraDynaset=OraDatabase.CreateDynaset("select*fromstudent",0&)'初始化动态集对象’添加记录'Begin an AddNewOraDynaset.DbAddNewOraDynaset.Fields("ID").value="1000"’ID为列名OraDynaset.DbUpdate'更新数据到表’删除OraDynaset.DbDelete'修改OraDynaset.DbEditOraDynaset.Fields("ID").value="101210"OraDynaset.DbUpdate

Answer 2

1cmd.Parameters.Add("@SHAYIN_ID", OracleDbType.Int32).Value = Convert.ToInt32(id)少个逗号cmd.Parameters.Add("@SHAYIN_ID", OracleDbType.Int,32).Value = Convert.ToInt32(id)2cmd.Parameters.Add("@SHAYIN_PASSWORD", OracleDbType.Varchar2, 32).Value = pass改成cmd.Parameters.Add("@SHAYIN_PASSWORD", OracleDbType.Varchar2, "32").Value = pass