Re: IDataReader.Read() throws Exception! How can i skip a row?
- From: "Patrice" <http://www.chez.com/scribe/>
- Date: Fri, 28 Nov 2008 10:03:11 +0100
So I'm afraid it messes the data stream. I would try an Oracle forum. Have
you tried to report this problem to those who could fix the DB ? I can't
imagine they are not willing to fix what seems a DB corruption ?
IMO trying to make an application able to work against a corrupted DB is
really not a solution.
I would skip this row not selecting this primary key and would definitely
report the problem to the db owner so that they can check and fix this
problem...
Good luck.
--
Patrice
"Venkat" <Venkat@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de
groupe de discussion : A8200ED9-5CCA-4271-ADBD-6F2BEB17CFF8@xxxxxxxxxxxxxxxx
Patrice,
Thanks for your response.
When using a try/catch block and trying to read again in the catch block
the
cursor is not valid (i get a "ORA-01002: fetch out of sequence" error).
Is there some sort of "peek" or "skip" in OracleDataReader so that I can
ignore the problematic row(s)?
And there's nothing I can do to fix the actual data :-(
-Venkat
"Patrice" wrote:
What happens when using try/catch ? (if the stream doesn't recover from
this you can't perhaps not continue).
That said, my personal preference would be likely to report this to
someone
that can fix this as working with a corrupted database is likely to cause
further problems (or avoid the row by not selecting this particular key
for
now)....
Possibly point them to :
http://dbcrusade.blogspot.com/2008/08/oracle-resolving-ora-29275-partial.html
That seems to show how to fix the DB...
--
Patrice
.
- References:
- Prev by Date: Re: Caching Parameters Performance Issue When Using SQLHELPER
- Next by Date: Re: Default value for a double
- Previous by thread: Re: IDataReader.Read() throws Exception! How can i skip a row?
- Next by thread: Re: IDataReader.Read() throws Exception! How can i skip a row?
- Index(es):
Relevant Pages
|
