Field ROWID is empty with 10gR2

dpsistemi · Post by **dpsistemi** » Mon 08 Oct 2007 15:24

Hi,

I use Delphi 5, Oracle 9.2.0.4, ODAC 5.50.0.15.
In several query i use the field ROWID for update / delete statement.
It's all ok.

I try to use a superior release of Oracle (es. 9.2.0.5, 10.1.0.3). All ok.

Today i try the relase 10.2.0.3, and I received an error "Field ROWID must have a value". Very Strange.

I try to execute the statement of Select with SQLPlus, and the field ROWID have some value.

I repeat the same query inside the Delphi, and i see that the field ROWID is empty.

What can i do ?
Thanks.

Please, don't tell me to upgrade the version of ODAC.

Plash · Post by **Plash** » Tue 09 Oct 2007 08:56

After you have opened the query, try to set the Required property for the TField object of the coresponding ROWID to False.