Accessing Oracle case sensitive ROWID from MS SQL Server

Asked Jun 23 '14 at 06:46

Active Sep 20 '14 at 18:20

Viewed 233 times

I am having a oracle table where the ROWID column is having data which is duplicate but as the field is case sensitive its considering it as 2 different rows eg. 'Test' and TEST are considered different.

when i am accessing this from MS SQL Server using ODAC, i am getting the error saying System.Data.ConstraintException:Failed to enable constraints.one or more rows contains values violating non null,unique or foreign key constraints.

Any way to query the data using ODAC?

Anyone faced similar issue?

edited Sep 20 '14 at 18:20

pnuts

58,317
11
87
139

asked Jun 23 '14 at 06:46

user3766289

1

Please post the query you are using to access the oracle data – Raj Jun 23 '14 at 07:01
Hi thanks for the response it got solved using OLEDB driver. – user3766289 Jun 24 '14 at 08:13
Voting to close as this question already has been solved by the poster. – jpw Sep 20 '14 at 19:04
1

`ROWID` is an Oracle internal unique identifier for a row. The "ROWID column" can **never** contain a value like `TEST`. – Sep 20 '14 at 19:09

Accessing Oracle case sensitive ROWID from MS SQL Server

0 Answers0