How to continue when exception occurs at DataReader.Read() method

See more:

C#

Windows

DataReader

Hi All,

Greetings!!!

I am facing a issue with IDataReader when trying to read a row from Database. I am having IDataReader object called objDataReader. The results are looped using while loop as below.

while(objDataReader.Read())
{
   // doing some work
}

Due to some problem in reading LONG data from database, the objDataReader.Read() is throwing exception(ORA-01062: unable to allocate memory for define buffer ) for a particular row. It is not possible to continue to next row after the exception.

Kindly advice me how to proceed to next row, even after getting exception in the objDataReader.Read() method.

Thanks in advance.