Error in Oracle while populating a Datatable - C# .NET

Question

When I try to populate a datatable of a Oracle table via .NET, I get error as

Here is the code that I used:

DataTable PRDTableResults = new DataTable();
using (OracleDataAdapter dataAdapter = new OracleDataAdapter())
{
  OracleCommand cmd = new OracleCommand("SELECT * from PRD");
  cmd.CommandType = CommandType.Text;
  cmd.Connection = conn;
  dataAdapter.SelectCommand = cmd;
  dataAdapter.Fill(PRDTableResults);
 }

I am not sure why such error showed up. The PRD table has fields with no precision and scale defined but as NUMBER.

Elkhan Ibrahimov · Accepted Answer · 2017-03-05 20:25:06Z

1

I faced this error before and I remember that it was caused by a bug in the Oracle ODBC driver. I don't remember version exactly, I think it affected for 10.2 and 11.2 version, and only in x64 bit driver.

So you can try this, set platform target from AnyCPU to X86 in properties of your application project.

answered Mar 5, 2017 at 20:25

Elkhan Ibrahimov

2443 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user7157732 Over a year ago

Interesting! Thnx

Collectives™ on Stack Overflow

Error in Oracle while populating a Datatable - C# .NET

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related