OraDirect .Net Mobile RecordsAffected problems

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
riccamen
Posts: 1
Joined: Fri 21 Nov 2008 15:59

OraDirect .Net Mobile RecordsAffected problems

Post by riccamen » Fri 21 Nov 2008 16:31

I've a problem with OraDirect .Net Mobile.
I have found some bugs

1)OracleDataAdapter.update() dont return the correct RecordsAffected rows.
it returns the number of the row in the DataTable then need to be update
but not the row that are reallly updated


2) OracleCommand.ExecuteNonQuery("UPDATE locazioni SET quantita=:qta where id=:id") return the correct number of updated rows ,but if you use RETURNING it always return -1

OracleCommand.ExecuteNonQuery("UPDATE locazioni SET quantita=:qta where id=:id RETURNING quantita INTO :qta ")

Shalex
Site Admin
Posts: 8246
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 24 Nov 2008 14:02

1) Could you please send me (alexsh*devart*com) a test project, a DDL and DML script to reproduce the problem?

2) This is a limitation of the direct mode: the correct number of affected rows is not returned when using the RETURNING construction.

P.
Posts: 1
Joined: Tue 24 Mar 2009 16:18

Post by P. » Tue 24 Mar 2009 16:24

Hi Shalex

We use direct mode and returning clause, too. Is there a way to find out if any changes had been made?

Thank you

Shalex
Site Admin
Posts: 8246
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 24 Mar 2009 17:24

You can use your command without the returning clause to get the number of rows affected. To return the changes from the database to your application, try using the select command after the command that affects the rows in your table.

Post Reply