Error ORA-00903
610527Nov 27 2007 — edited Nov 28 2007Hi,
i receive the Error ORA-00903 when i try to execute a SELECT statement in a C# program, which is working in SQL Plus.
Here the program:
OracleCommand ocom;
OracleConnectionStringBuilder ocb;
OracleConnection oc;
ocb = new OracleConnectionStringBuilder();
ocb.DataSource = "XXX";
ocb.Password = "xxx";
ocb.UserID = "xxx";
oc = new OracleConnection(ocb.ConnectionString);
oc.Open();
ocom = new OracleCommand("select ordernr from order", oc);
try
{
OracleDataReader or = ocom.ExecuteReader();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
I am using VS2005 on WIndows Vista 64 Enterprise and the ORACLE DATA PROVIDER FOR .NET 11.1.0.6.10 BETA. It's the only one which works with Vista 64, as i know.
best regards
Erwin