I accessed that you're trying to retrieve the column type of the table, like for example varchar, number, lob etc etc. If that's the case, you could use the DESCRIBE feature in oracle, however, the describe command will only display the results in query windows. If you wish to have it dynamic in order to embed the column type into your algorithm, you can use the alternative method as shown in this link -> Desc - Describe an Oracle Table, View, Synonym, package or Function | SS64.com
Hope it helps..
1 person found this helpful
The following C# code shows how to get the OracleDbType from the schema table:
DataTable schemaTable = reader.GetSchemaTable();
//retrieve the first column info.
DataRow row = schemaTable.Rows;
//print out the column info
Console.WriteLine("Provider Type: " + (OracleDbType)row["ProviderType"]);
No problem, glad i'm of some help.