连接oracle数据库,执行dml语句是否要加commit

[pastime_Wang]

通过引用oracleclient.dll,使用ado.net执行dml语言（insert\update\delete）时,ado.net中是否默认自动提交(commit)?

是否要在执行的DMLSQL语句中加入COMMIT ?

如果不是，请教如何编写，自动提交？

谢谢！

[cgipro]

'=====================================================================================================
'目的：
' 执行non-query SQL，如果有异常， psOutErrMsg 返回错误信息
'-----------------------------------------------------------------------------------------
'输入：
' psSQL
'输出：
' True: 执行OK
' False : 执行Fail
'=====================================================================================================
Public Function ExecSQL(ByVal psSQL As String, ByRef psOutErrMsg As String) As Boolean
Dim dtCmd As OracleCommand
Dim cnADO As New OracleClient.OracleConnection
Dim rtResult As Boolean

Try

psOutErrMsg = ""
cnADO.ConnectionString = sConnStr
cnADO.Open()
dtCmd = New OracleCommand(psSQL, cnADO)
dtCmd.ExecuteNonQuery()
rtResult = True
Catch OraEx As OracleException
psOutErrMsg = OraEx.Message & " SQL: " & psSQL
rtResult = False
Catch ex As Exception
psOutErrMsg = ex.Message
rtResult = False
Finally
dtCmd.Dispose()
cnADO.Close()
End Try
Return rtResult
End Function

[cgipro]

cnADO.ConnectionString = sConnStr
cnADO.Open()
dtCmd = New OracleCommand(psSQL, cnADO)
dtCmd.ExecuteNonQuery()