Year, Month, and Day parameters describe an un-representable
666587Oct 22 2008 — edited Oct 22 2008Hi There,
I'm making this update in my Oracle 10g DB:
PARSING IN CURSOR #135 len=75 dep=0 uid=44 oct=6 lid=44 tim=1308401482 hv=2730567848 ad='71acfba8'
UPDATE CIC.PERSON SET GEBDATUM = :GEBDATUM_ WHERE SYSPERSON = :SYSPERSONk0
END OF STMT
PARSE #135:c=0,e=114,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1308401479
BINDS #135:
kkscoacd
Bind#0
oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
oacflg=07 fl2=1000000 frm=00 csi=00 siz=32 off=0
kxsbbbfp=162ffb20 bln=07 avl=07 flg=05
value="0/0/0 0:0:0"
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=13
oacflg=07 fl2=1000001 frm=00 csi=00 siz=0 off=8
kxsbbbfp=162ffb28 bln=22 avl=04 flg=01
value=14185
This update goes smoothly.
Now I try to read this Date field from my DB and I get this exception.
System.ArgumentOutOfRangeException was unhandled
Message="Year, Month, and Day parameters describe an un-representable DateTime."
Source="mscorlib"
StackTrace:
at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)
at Oracle.DataAccess.Client.OracleDataReader.GetDateTime(Int32 i)
at DateTimeTest.Program.Main(String[] args) in C:\projects\DateTimeTest\DateTimeTest\Program.cs:line 34
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:
Whats wrong? Ho do I prevent it from happening?
Regards,
M