Error when i fill dataset

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
hrva

Error when i fill dataset

Post by hrva » Thu 28 Jul 2005 09:10

I have table "kaf_artikli" in oracle databse.

When I try to fill dataset I get this error:

An unhandled exception of type 'CoreLab.Oracle.OracleException' occurred in CoreLab.Oracle.dll

Additional information: ORA-00942: table or view does not exist

But I have this table in database!

This is code from your example:

Cursor.Current = Cursors.WaitCursor;
OracleDataAdapter.Fill(dataSet,"kaf_artikli");
dataGrid.DataSource = dataSet.Tables[0];

Why this happening?

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Post by Oleg » Wed 03 Aug 2005 09:17

Second parameter in call of OracleDataAdapter.Fill(dataSet,"kaf_artikli");
doesn't concern table name at the server.
Please specify your OracleDataAdapter.SelectCommand.CommandText.
Try to assign table name in CommandText and TableDirect in CommandType:

Code: Select all

OracleDataAdapter.SelectCommand.CommandType = CommandType.TableDirect
OracleDataAdapter.SelectCommand.CommandText = "kaf_artikli"

Post Reply