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 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.