ORA-01410: invalid ROWID

[wingover]

Hello,

Oracle version: 10g Release 10.1.0.2.0

Query: SELECT CLIENTS.*, CLIENTS.ROWID FROM CLIENTS

Language: Delphi 7 Enterprise

Here is an output from SQL Plus with Query:

select clients.rowid, clients.clientid from clients;

ROWID CLIENTID
------------------------ ---------
*BAEAAgwJMzMwMTQ0MzQ2/g 330144346
*BAEAAgwJNDA2ODEyMTU1/g 406812155
*BAEAAgwJNDY1ODAyODY2/g 465802866
*BAEAAgwJNjIwNzM0ODM3/g 620734837
*BAEAAgwJNjUzNTM3NTI4/g 653537528

In a DBGrig when parsing through records the OracleDataSet1.ROWID takes on these values:

ROWID CLIENTID
------------------ ---------
*BAEAAgwJMzMwMTQ0M 330144346
*BAEAAgwJNDA2ODEyM 406812155
*BAEAAgwJNDY1ODAyO 465802866
*BAEAAgwJNjIwNzM0O 620734837
*BAEAAgwJNjUzNTM3N 653537528

Since the ROWID returned from OracleDataset1.ROWID does not correspond to the ROWID returned from SQL Plus, whenever I try OracleDataset1.Edit or OracleDataset1.Delete, I get the error message ORA-01410: invalid ROWID.

Why is OracleDataset1 truncating the last 4 characters?

I would deeply appreciate any help you can offer.

Thanks

Wingover

 

[wingover]

I forgot to mention I'm using DOA 4.0.6.2

Wingover