I have a field in Oracle database table which is of datatype LONG. I want to display its contents. When i try to store the contents of this field into a variable :<BR>strmemotxt = objRsTest.Fields("memo_data").value<BR>i get the following error :<BR>----------------------------------------<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e21&#039 <BR><BR>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. <BR><BR>----------------------------------------<BR>and the field attribute using Fields("memo_data").attributes method shows as 230.<BR><BR>I even tried strmemotxt = objRsTest.Fields("memo_data").GetChunk(100) but even this statement gives the above mentioned error. <BR><BR>What is going wrong here?<BR>can anyone help?<BR><BR>regards<BR>Gaurang