Fetching ROWID

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
SDIConsulting
Posts: 1
Joined: Sun 18 Jun 2006 12:42

Fetching ROWID

Post by SDIConsulting » Sun 18 Jun 2006 12:53

Hello,

I have a SQL statement returning the ROWID of each selected record:
"SELECT ROWID, C_NAME FROM PERSONS ORDER BY ROWID"

When executing a reader (OracleDataReader), I can fetch this ROWID with GetString(index) but this ROWID is not valid.

Fetched value has 9 characters lenght but a ROWID value has always a 18 characters lenght (ASCII).

In facts, the connection is set as Unicode (mandatory for my application) and the loaded ROWID has 9 unicode characters.

Who can tell me how to retrieve a correct ROWID ?
Perhaps by changing my SQL statement ?

Thanks in advance.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 19 Jun 2006 06:51

What is the verion of your OraDirect .NET?
Please download the latest one from our site and use it.

Post Reply