Returning Long Datatype from Oracle database in .Net

From: Katie <k.mccowen_at_link-hrsystems.com>
Date: Thu, 11 Mar 2004 17:05:53 -0000
Message-ID: <10517eva353j103@corp.supernews.com>

Hi all
I am trying to return a field which is of long datatype from an Oracle 9i database. I am accessing the database with ODP.NET, but the only thing being returned is an empty string.
Here is an example of the code I am using:

string strSQL = "SELECT <Long field> from <Table>"; OracleConnection strConnection = new OracleConnection(

"Data Source=<datasource>;" +
"User Id=<user>;" +
"Password=<password>;");

strConnection.Open();
DataSet objDataSet = new DataSet();
OracleDataAdapter objDataAdapter = new OracleDataAdapter(strSQL, strConnection); objDataAdapter.Fill(objDataSet, "Table"); DataView objDataView = new DataView(objDataSet.Tables["Table"]); dgUsers.DataSource = objDataView;
dgUsers.DataBind();
strConnection.Close();

Any help with this would be appreciated
Thanks
Katie Received on Thu Mar 11 2004 - 11:05:53 CST