Page 1 of 1

OracleDataReader fetches first 6 columns only

Posted: Mon 11 Apr 2005 11:48
by Byte
I've created OracleCommand with select * from MY_VIEW as CommandText. The type of a command is "Text".

When I try to execute this command, storing the result in a OracleDataReader (OracleCommand->ExecuteReader), I have a trouble with reader's columns. When I refer to the first 6 columns of a result set, I see what I want. But, reading the values of others columns of any row in a reader gets the null result.

Is it because of using a trial version of component?

Thanks!

Posted: Tue 12 Apr 2005 09:44
by Guest
More concrete, the problem is in a result set of the OracleCommand. I use OracleCommand object as the SelectCommand in OracleDataAdapter, and the result is the same. Please, HELP!!

Posted: Tue 12 Apr 2005 14:09
by Oleg
This is trial limitation.
OraDirect .NET trial version returns record sets with maximum 6 columns.

Posted: Wed 08 Jun 2005 14:14
by Alex30
I have the same exact problem.

But I had trial version installed on the server. Then I tried to install the professional version. But it told me that I had to uninstall the previous version. However, During the uninstall process, I would always get error, and it would not go through.

So I just removed the directory and all the registry settings that I could find. Then I have installed the Proffessional version, but I still get only 6 records.

Can some one help me?

Alex

Posted: Thu 09 Jun 2005 12:39
by Paul
Try to find another copy of CoreLab.Oracle.dll on your compute. Check in debugger which copy of CoreLab.Oracle.dll is loaded in your application.