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.

Apparently the column is reported as "required". You will need to define it as an internally calculated fied (ftInternalCalc).

Hi Marco,

Thanks for the reply.

We understood your proposal, but why our appliction still runs on Oracle 9i without any source code modification? Is this TOracleDataset behavior on Oracle 10g indicating a possible bug, maybe in DOA source code?

Considering that our applications is too big to share in the modifications proposed, is there another solution we should try to make it work on Oracle 10g? Perhaps an easy one, with some simple implementation in DOA source code?

Best Regards.

The symptoms suggest that this is a behavioral change in Oracle10g. We'd have to look into this first before I can answer this. If you could send me a small testcase to reproduce the issue?

Hi Marco,
We have sent you the testcase by email.
We are waiting for your results.
Best Regards.

can odac connect to column of ordaudio type of inermedia oracle database

can odac table comopnent conect to an oracle 9i column of ordvideo type

Hi Marco,
Did you reproduce the problem in Oracle 10g?
Best Regards.

Hi Marco,
Is there any patch to solve this problem?
Best Regards.

Sorry for the delay. We'll hopefully have a patch available shortly.