wierd exception

  • Thread starter Thread starter Sebastián_UY
  • Start date Start date
S

Sebastián_UY

Hi All!
I'm using the Microsoft .Net Data Provider for Oracle, I used the one from
Oracle but I found the one from Microsoft better.
The thing is that every once in a while and with no particular reason when
I'm deleting a record it gives me a not a valid month exception (ORA-01843).

The records I try to delete have a date field but the date is always in the
"01/01/YYYY" format, so the moth should never be a problem. The wierd thing
is that that's a random error, if I get to delete it and write it back and
try to delete it again I might get that error.

I have no clue and any help would be appreciated.
TIA,
Sebastián

--
Ing. Sebastián Gómez Correa
----------------------------------------------
(e-mail address removed)
Jefe Administrador Desarrollo Administrativa
Poder Judicial - División Tecnología
Montevideo - URUGUAY
----------------------------------------------------------------------------
 
Hi,

Are you sure that it is happening when you delete row?
Are you using parameters?
What is your code?
 
Hi Miha, thanx for you quick answer.
I'm positive about that.

I can copy the sql sentence while debugging and execute it via SQL Plus and
it works fine.
No parameters at all, not there, I also execute some stored procedures but
have no problem with that.


--
Ing. Sebastián Gómez Correa
----------------------------------------------
(e-mail address removed)
Poder Judicial - División Tecnología
Montevideo - URUGUAY
----------------------------------------------------------------------------
----------------------
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
----------------------------------------------------------------------------
----------------------
Miha Markic said:
Hi,

Are you sure that it is happening when you delete row?
Are you using parameters?
What is your code?

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Sebastián_UY said:
Hi All!
I'm using the Microsoft .Net Data Provider for Oracle, I used the one from
Oracle but I found the one from Microsoft better.
The thing is that every once in a while and with no particular reason when
I'm deleting a record it gives me a not a valid month exception (ORA-01843).

The records I try to delete have a date field but the date is always in the
"01/01/YYYY" format, so the moth should never be a problem. The wierd thing
is that that's a random error, if I get to delete it and write it back and
try to delete it again I might get that error.

I have no clue and any help would be appreciated.
TIA,
Sebastián

--
Ing. Sebastián Gómez Correa
----------------------------------------------
(e-mail address removed)
Jefe Administrador Desarrollo Administrativa
Poder Judicial - División Tecnología
Montevideo - URUGUAY
Click to expand...
Click to expand...
 
Hi,

I would look for secondary commands such as triggers and stuff like that .
Try excluding them and see if errors reappear.
 
Back
Top