Problem in updating dataset using DAAB (enterprise library 2006).

[Dharmen Patel]

I am using Enterprise Library 2006 , Data Access Application Blocks.
1. I am connecting to Oracle 9i database using DAAB.
2. I retrieve a dataset using the following code in VB.NET.
Dim sqlCommand As String = "SP_GET_BATCH"
Dim dbCommand As DbCommand
dbCommand = db.GetStoredProcCommand(sqlCommand)
ds = db.ExecuteDataSet(dbCommand)

3. I update the dataset using the following code.
ds.Tables["Table"].Rows[0]["PRODUCTION_SEQUENCE_NO"] = 5111
ds.Tables["Table"].Rows[1]["PRODUCTION_SEQUENCE_NO"] = 5112
ds.Tables["Table"].Rows[2]["PRODUCTION_SEQUENCE_NO"] = 5113
ds.Tables["Table"].Rows[3]["PRODUCTION_SEQUENCE_NO"] = 5114
ds.Tables["Table"].Rows[4]["PRODUCTION_SEQUENCE_NO"] = 5115

4. I update the database using the following code.
DbCommand updateCommand = db.GetStoredProcCommand ("SP_MOVE_TURBO_BAT")
db.AddInParameter(updateCommand, "p_batch_id", DbType.Int32, "BATCH_ID", DataRowVersion.Current)
db.AddInParameter(updateCommand, "p_prod_seqno", DbType.String, "PRODUCTION_SEQUENCE_NO", DataRowVersion.Current);
// Submit the DataSet, capturing the number of rows that were affected
int rowsAffected = db.UpdateDataSet(productsDataSet, "Table", null, updateCommand, null, UpdateBehavior.Standard);
return rowsAffected;


Now, there are 5 rows whose values are updated.But, the changes at database are reflected only in 4 rows.

This is typical scenario which I am facing.Please help me on this.