Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Year, Month, and Day parameters describe an un-representable

666587Oct 22 2008 — edited Oct 22 2008
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2008
Added on Oct 22 2008
1 comment
2,698 views