I faced a problem with .Net 2.0 application working with oracle database using Entrprise Library

Application installed on Win 2003 web server and oracle insalled on Sun Solaris 64 bit

The problem I faced was, in select statments, if i run a page have a select statement in page load, it's some times work and other times not work with no rules in this issue, this confused me too much

my select statement like this;

select * from Employees where employeeID=10

After testing many trial, i found unlogical reason for this problem

I found if the column name length more than 8 character its making problems in IDataReader Object calling eg: data["CONTACT_METHOD_ID"]

the reason was column name length "contact_method_id"

i changed my select using alias naming to be like

select CONTACT_METHOD_ID cntmthID from Employees where employeeID=10

data["cntmthID"]

then the system work with no any problems

the important not is this error is not appearing in oracle installed on Windows operating systems

Can anyone till me, what is the reason, or this is a bug in Enterprise Library?

=================

Wael Nofal, Software Developer, TacMe.Com