找不出错的点，总是报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 = passDim count As IntegerTrycount = cmd.ExecuteNonQuery()Catch ex As ExceptionEnd TryIf count > 0 Thenflag = TrueElseflag = FalseEnd Iflogin = 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*from

student",0&)'初始化动态集对象
’添加记录
'Begin an AddNew
OraDynaset.DbAddNew
OraDynaset.Fields("ID").value="1000"
’ID为列名
OraDynaset.DbUpdate'更新数据到表
’删除
OraDynaset.DbDelete
'修改
OraDynaset.DbEdit
OraDynaset.Fields("ID").value="101210"
OraDynaset.DbUpdate

Answer 2

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