Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim connection As OracleConnection = Nothing
- Dim transaction As OracleTransaction = Nothing
- Try
- connection = New OracleConnection("Data Source=ora10;User Id=userid;Password=passwd;")
- connection.Open()
- transaction = connection.BeginTransaction(IsolationLevel.Serializable)
- Dim inputStream As New System.IO.FileStream("Dummy.xls", IO.FileMode.Open)
- Dim fileLength As Integer = CType(inputStream.Length, Integer)
- Dim input(fileLength) As Byte
- Try
- inputStream.Read(input, 0, fileLength)
- Finally
- If inputStream IsNot Nothing Then inputStream.Close()
- End Try
- Dim deleteSql As String = "DELETE FROM TABLE1 WHERE Version = 'v1' "
- Dim cmd As New OracleCommand(deleteSql, connection, transaction)
- cmd.ExecuteNonQuery()
- Dim insertQuery As String = "INSERT INTO TABLE1 (VERSION, DATA) VALUES (:VERSION, :DATA) "
- Dim insertCmd As OracleCommand = New OracleCommand(insertQuery, connection, transaction)
- insertCmd.Parameters.Clear()
- insertCmd.CommandType = Data.CommandType.Text
- insertCmd.Parameters.AddWithValue(":VERSION", "v1")
- insertCmd.Parameters.AddWithValue(":DATA", input)
- insertCmd.ExecuteNonQuery()
- transaction.Commit()
- Catch
- If transaction IsNot Nothing Then transaction.Rollback()
- Throw
- Finally
- If transaction IsNot Nothing Then transaction.Dispose()
- If connection IsNot Nothing AndAlso connection.State <> ConnectionState.Closed Then connection.Close()
- End Try
- transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted)
- (New OracleCommand("ALTER SESSION SET SQL_TRACE=TRUE", connection, transaction)).ExecuteNonQuery();
Add Comment
Please, Sign In to add comment