Re: wierd exception by Sebastián_UY
Sebastián_UY
Fri Feb 06 12:19:26 CST 2004
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
----------------------------------------------
sgomez@poderjudicial.gub.uy
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 [MVP C#]" <miha at rthand com> wrote in message
news:OIYPL2K7DHA.2628@TK2MSFTNGP10.phx.gbl...
> 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" <NOSPAM_sgomez@poderjudicial.gub.uy> wrote in message
> news:OcKVAcK7DHA.3420@TK2MSFTNGP11.phx.gbl...
> > 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
> > ----------------------------------------------
> > sgomez@poderjudicial.gub.uy
> > Jefe Administrador Desarrollo Administrativa
> > 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.
>
> --------------------------------------------------------------------------
> --
> > ----------------------
> >
> >
>
>