When using a generic DbCommand to perform an update, it will hang indefinately if the row being updated is locked. The underlying connection used is is Devart's Oracle provider, Devart.Data.Oracle.OracleConnection Setting the DbCommand.CommandTimeOut has no effect at all, the update never times out. DbCommand does not implement BeginE...
Hi, Is it possible to group OracleCommand objects and iterate through each OracleCommand in the collection? Could someone post a sample code in achieving this? Thanks. Angelo ...
I have the following code: OracleConnection conn = new OracleConnection(connString); OracleCommand command = new OracleCommand("select * from testtable", conn); conn.Open(); OracleDependency.Port = 2010; OracleDependency dependency = new OracleDependency(command); command.AddRowid = true; command.Notification.IsNotifiedOnce = false; de...
I am using System.data.Oracleclinet.OracleCommand.ExecuteNonQuery() to run my stored procedure. I observer the following strange thing. When execution runs throught COmmand.executeNonQuery it is giving 1 as the return value 1. But the stored procedure is not run and the output variable shows empty value({}). But if I run the same(comm...
Hi, I built a small query tool for Oracle using OracleCommand and OracleDataAdapter. Users just input a full query (no parameters), execute and the results are shown in a datagridview. So far so good, although I tried an invalid query, e.g.: SELECT * FROM mytable WHERE dateColumn = '1-JAN-10' This query is not valid SQL for Oracle. Y...
I am using the following code to update a table in oracle. It executes but the update does not commit. If I run the query with Oracle SQL Developer it works fine. What am I missing? SELECT statements work as expected. `Dim BillOfLadingNumber As String = txtBillOfLadingNumber.Text.Trim Dim TrailerNumber As String = txtTrailerNumber....