Load Listview with data from Oracle LONG data type
Is it possible to load a listview with data from an Oracle column of LONG datatype? When I run the following code, I get an error. I can run the query in SQL+ so I know the syntax is correct.
Error:
ERROR [22018] [Microsoft][ODBC driver for Oracle][Oracle]ORA-00932: inconsistent datatypes: expected LONG got CHAR
Code:
rsSource.CommandText = "select name,default$ from sys.col$"
rdrSource = rsSource.ExecuteReader
Do While rdrSource.Read
lstItem = New ListViewItem
lstItem.Text = rdrSource.Item("name")
lstItem.SubItems.Add(rdrSource.Item("default$"))
frmMain.lvSourceColumns.Items.Add(lstItem)
Loop
rdrSource.Close()