ODP.NET

I'm reading data into a DataTable with for example the SQL statement
'SELECT t1.A, t2.B from TABLE1 t1, TABLE2 t2 where t1.A = t2.B'.

I make changes to the DataTable and then I want to save the changes made using the DataAdapter's Update command, but this fails.

If I'm using the CommandBuilder I feed it with the select statement "SELECT * FROM TABLE1" for updating TABLE1.

When I call DataAdapter.Update I get the error:

"Dynamic SQL generation failed. Either no base tables were found or more than one base table was found"

I have tried creating my own update commands, but apart from being unnessecary work, this also fails with Oracle.DataAccess.Client.OracleException.

Using the Microsoft .NET Oracle client dynamic SQL generation works and update works using the exact same code.

Thanks for any help!
Björn Andersson