Troubleshooting Oracle Universal Data Access 11.2

Enterprise Architect supports many databases, to store it’s models to.
Oracle is one of them.
And many companies use Oracle’s default drivers named OraOleDb.

So do I. But lately I experienced a strange behavior:

select * from t_object

didn’t deliver all the values, I would have expected. Instead, some values from column pdata3 were missing. But

select * from t_object order by OBJECT_ID

worked fine.

What was the difference? I used the ODAC drivers 11.2.0.1 which are known for having problems with BLOB and CLOB fields.
What was the solution: update the drivers to at least revision 2, and the simple select won’t miss any values any more.

Hinterlasse eine Antwort

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind markiert *

Du kannst folgende HTML-Tags benutzen: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>