Why is GetOracleDecimal() valid but not GetOracleDateTime() ?

[Pia Stevens]

In a program I coded:

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;
.....

OracleDecimal num = reader.GetOracleDecimal(reader.GetOrdinal("MYNUM"));
OracleDateTime ts = reader.GetOracleDateTime(reader.GetOrdinal("MYDATE"));

The first fetch statement (GetOracleDecimal) statement passed successfully
the compiler while the second (GetOracleDateTime) yields a compiler error:

The type or namespace name 'OracleDataTime'could not be found"

Why ?

Pia

 

[Jon Skeet [C# MVP]]

In a program I coded:

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;
....

OracleDecimal num = reader.GetOracleDecimal(reader.GetOrdinal("MYNUM"));
OracleDateTime ts = reader.GetOracleDateTime(reader.GetOrdinal("MYDATE"));

The first fetch statement (GetOracleDecimal) statement passed successfully
the compiler while the second (GetOracleDateTime) yields a compiler error:

The type or namespace name 'OracleDataTime'could not be found"

Well, the error message you've given doesn't tie in with the code
you've given: GetOracleDataTime vs GetOracleDateTime (date vs data).

Which have you *actually* got in your code?

Jon