I have a field in Oracle database table which is of type LONG. 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 gets displayed as 230.<BR><BR>What is going wrong here?<BR>can anyone help?<BR><BR>GKG