执行指令没问题的,其中的SQLString就是上面的创建数据表或插入记录的SQL字符串,S_ConnectString也是没问题的 Dim S_OracleConnection As OracleConnection Dim S_OracleCommand As New OracleCommand Dim S_Transaction As OracleTransaction Try S_OracleConnection = New OracleConnection(S_ConnectString) S_OracleConnection.Open() With S_OracleCommand .CommandType = CommandType.Text .CommandText = SQLString .Connection = S_OracleConnection End With S_Transaction = S_OracleConnection.BeginTransaction() S_OracleCommand.Transaction = S_Transaction S_OracleCommand.ExecuteNonQuery() S_Transaction.Commit() S_OracleConnection.Close() S_OracleConnection.Dispose() S_OracleCommand.Dispose() Catch E As Exception If Not S_Transaction Is Nothing Then S_Transaction.Rollback() End If M_ErrMessage = E.Message RaiseEvent OnChangedMessage(Me, E.Message) Return False End Try
ORA-01036: illegal variable name/number Cause: Unable to find bind context on user side Action: Make sure that the variable being bound is in the sql statement.检查一下values后面的值,是否有某个漏了引号而被解析为变量
执行指令没问题的,其中的SQLString就是上面的创建数据表或插入记录的SQL字符串,S_ConnectString也是没问题的 Dim S_OracleConnection As OracleConnection
Dim S_OracleCommand As New OracleCommand
Dim S_Transaction As OracleTransaction
Try
S_OracleConnection = New OracleConnection(S_ConnectString)
S_OracleConnection.Open()
With S_OracleCommand
.CommandType = CommandType.Text
.CommandText = SQLString
.Connection = S_OracleConnection
End With
S_Transaction = S_OracleConnection.BeginTransaction()
S_OracleCommand.Transaction = S_Transaction
S_OracleCommand.ExecuteNonQuery()
S_Transaction.Commit()
S_OracleConnection.Close()
S_OracleConnection.Dispose()
S_OracleCommand.Dispose()
Catch E As Exception
If Not S_Transaction Is Nothing Then
S_Transaction.Rollback()
End If
M_ErrMessage = E.Message
RaiseEvent OnChangedMessage(Me, E.Message)
Return False
End Try
Cause: Unable to find bind context on user side
Action: Make sure that the variable being bound is in the sql statement.检查一下values后面的值,是否有某个漏了引号而被解析为变量