Page 1 of 1

ROWNID must have a value Oracle 11gR2

Posted: Fri 07 Dec 2012 12:27
by shamilsons
Hi,

We use Delphi 5, ODAC 5.50.0.15, Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production.
We recently upgraded from Oracle 10R1 to Oracle 11gR1 and in our projects we started getting error ROWNID must have a value during insert or update, even thought in our queries we NEVER use ROWID field in inserts or updated for the records.

How to resolve this issue.

Re: ROWNID must have a value Oracle 11gR2

Posted: Fri 07 Dec 2012 13:26
by AlexP
Hello,

We cannot reproduce the described problem.
You are using a rather old ODAC version, try to reproduce the problem on the latest ODAC 8.5.10. If the problem repeats on the latest version, please send the query text, the script for creating the table, and a small sample demonstrating the problem.