OracleDataAdapter in ODP.NET RRS feed

  • Question

  • User-1542763163 posted

    Hi everybody,
    I have a problem with ODP.NET.

    When I used to use the old System.Data.OracleClient in Framework 1.1, this code worked perfectly:

    string strSQL = "SELECT * FROM MYTAB";
    da.SelectCommand.CommandText = strSQL;
    da.Fill(ds, "myQuery");

    This was enough to get the values of my query --> ds.Tables["myQuery"].Rows[0]["myCol"]

    But now, with ODP.NET and Framework 4, I get an error on the "Fill" method: ORA-00942: table or view does not exist.
    Why? Something has changed?

    Any hint is really appreciated.
    Thank you

    Friday, May 11, 2012 4:15 AM

All replies