updating blob Posted on: January 03 2003 11:12 GMT -08:00



Code:
I'm using this code to insert a blob into my Oracle db, it works fine. The problem I'm having is when I try to update an existing blob. The update looks good when I run the app. I don't get any errors, but when I go to open my blob (.pdf) it has a size of 0 bytes and the .pdf doesn't open. Does anyone know how to update an existing blob field? 

Dim sqlCmd As String = "insert into pbss.pbss_bid (bid_id, bid_type_code,buyer_name, bid_document, post_to_internet_ind) " 
                sqlCmd = sqlCmd & "values (?,?,?,?,?)" 
                Dim objCommand As New OleDbCommand(sqlCmd, objConnection) 
                objCommand.Parameters.Add("@bid_id", System.Data.OleDb.OleDbType.VarChar, 5).Value = txtBidId.Text 
                objCommand.Parameters.Add("@bid_type_code", System.Data.OleDb.OleDbType.Numeric, 2).Value = Bid_Type 
                objCommand.Parameters.Add("@buyer_name", System.Data.OleDb.OleDbType.VarChar, 45).Value = txtBuyerName.Text 
                objCommand.Parameters.Add("@bid_document", System.Data.OleDb.OleDbType.Binary, 27086).Value = FileByteArray 
                objCommand.Parameters.Add("@post_to_internet_ind", System.Data.OleDb.OleDbType.Integer).Value = Post_to_Int 
                objConnection.Open() 
                objCommand.ExecuteNonQuery()