Dim iRet As Integer = 0 sSql = "INSERT INTO RECIPEINFO VALUES('" & sRecipeName & _ "','" & sMcNo & "','" & sMcType & "','" & sLotNo & "','" & sDevice & _ "','" & sRecipeStatus & "','" & sEmpNo & "','" & sIndicator & "','" & sMode & "',:DateTime,:Data)" 'cmd = New SqlCommand(sSql, myConnection) cmd = New OracleCommand(sSql, myConnection) cmd.Parameters.Add(New OracleParameter(":Data", OracleDbType.Blob, 500, "Data")) cmd.Parameters.Item(":Data").Value = buffer 'executing the command and assigning it to connection iRet = cmd.ExecuteNonQuery() cmd = Nothing myConnection.Close()
:DateTime
:Data
VALUES(...)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)