Hi Marco,

Our application runs on Oracle 9.2.0.6.0 but does not run on Oracle 10.2.0.1.0.

When inserting records in a view using TOracleDataset we receive the following message: "Field RID must have a value". This view has a virtual column called RID. This column points to ROWID table column.

We do know that changing RequiredFields property to FALSE eliminates the problem on Oracle 10g, but why the application still works on Oracle 9i without any code change?

For example, the following select statement for SQL property WORKS on both Oracle 9i and 10g:

select a.col1, a.col2, ... , a.colN, a.rowid from view_name a

But the same select statement wrote in a different way DOES NOT WORK on Oracle 10g:

select a.*, a.rowid from view_name a

We are using DOA 4.0.7.1

Can you help us?

Best Regards.