Hello Hubert,
Hmmm... I never did try filling a data set with a timestamp. Only selecting and inserting via a parameter.
Internally, OracleDateTime uses a System.DateTime. This should change. We should separate the various parts in OracleDateTime. I will look into System.DateTime to see how its
Hello Hubert,
I committed to svn trunk HEAD support for Oracle TIMESTAMP using an
OciDateTime descriptor.
It is svn revision 48254.
Please let me know if this works for you or not.
Thanks,
Daniel
Hubert FONGARNAND wrote:
I really need the new TimeStamp type (supported starting from oracle
You may need to allocate a TimeStamp descriptor. OciHandle might need
to be modified to create a TimeStamp descirptor. See the difference
between a DATE and TIMESTAMP in table 3-2 below. Notice how DATE is a
char[7] while TIMESTAMP is a descriptor which uses opache type of
OCIDateTime.
I really need the new TimeStamp type (supported starting from oracle 9). It's
a MS.NET supported type (i've made tests)...
I've begin to do a little patch (attached) to add the timestamp type to
oracle.client...
but... I've a strange error when i try to do a Fill, it failed with:
Unhandled
You need to modify OciDefineHandle to deal with the TIMESTAMP.
See Define(), DefineDate(), and GetValue().
You can create a new function called DefineTimestamp() based on
DefineDate() and allocate space for it based OciDataType.TimeStamp.
What about TIMESTAMP WITH TIMEZONE and TIMESTAMP WITH