oraoledb oracle,OraOLEDB.Oracle

connection string is "Provider=OraOLEDB.Oracle;Data Source=ORCL;User ID=system;password=password;"

Dim objDa As New OleDb.OleDbDataAdapter("select * from Table where id= 1", cnnXn)

Dim objCB As New OleDb.OleDbCommandBuilder(objDa)

Dim objDS As New Data.DataSet

Dim objRow As Data.DataRow objDa.Fill(objDS)

If objDS.Tables(0).Rows.Count = 0 Then 'insert

REM -- insert

objRow = objDS.Tables(0).NewRow()

.

.

REM -- add

objDS.Tables(0).Rows.Add(objRow)

objDa.Update(objDS)

else

REM -- update

objRow = objDS.Tables(0).Rows(0)

.

.

REM -- update

objDa.Update(objDS)

End If

id column is primary key.

insert works fine but on update I' ve got error

System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet) at WindowsApplication1.Form1.setFile(Int64 nDocId, XmlDocument xmlDoc) in ..