Error when trying to get Oracle timestamp datatype

[richard green]

Hi,
I have the following code,

OleDbDataAdapter dbAdapter = new OleDbDataAdapter("select
insertdatetime from table_name, conn));

DataSet ds = new DataSet();

dbAdapter.Fill(ds);

The field insertdatetime is of type TIMESTAMP(6). I am getting the
following error when the Fill method is called -

Unspecified error Oracle error occurred, but error message could not
be retrieved from Oracle. Data type is not supported.

Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unspecified error
Oracle error occurred, but error message could not be retrieved from
Oracle. Data type is not supported.

What can be the cause for this and is there any workaround for it?

Thanx
richard

 

[Cowboy \(Gregory A. Beamer\)]

Have you also tried the OracleClient namespace. That would be the first
place I would attempt to look. If this does not work, you can cast the
timestamp as a string for display.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************

 

[Miha Markic]

Hi richard,

Try to create strong typed dataset and see what happens.