|
-
May 31st, 2013, 11:11 AM
#1
Thread Starter
New Member
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()
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|