On Mon, Jun 06, 2005 at 10:48:56AM +0200, Honza Pazdziora wrote: > > which got me happy since it gives me the interval value alright. > > Please let me know if I should do some more tests for other rare > types of 10g. If you give me a hint how 10g-specific tests should be > done in t/*.t, I can provide some additions to the test suite as > well.
The ocidfn.h oracle header file lists these types: #define SQLT_DATE 184 /* ANSI Date */ #define SQLT_TIME 185 /* TIME */ #define SQLT_TIME_TZ 186 /* TIME WITH TIME ZONE */ #define SQLT_TIMESTAMP 187 /* TIMESTAMP */ #define SQLT_TIMESTAMP_TZ 188 /* TIMESTAMP WITH TIME ZONE */ #define SQLT_INTERVAL_YM 189 /* INTERVAL YEAR TO MONTH */ #define SQLT_INTERVAL_DS 190 /* INTERVAL DAY TO SECOND */ #define SQLT_TIMESTAMP_LTZ 232 /* TIMESTAMP WITH LOCAL TZ */ looks like a few are missing and 183 was a typo. (Of course there are probably more exotic types that don't have explicit support in DBD::Oracle yet). I've changed 183 to 190 and checked the change (and your test patch, thanks) into subversion - so you can patch against that version :) Thanks! Tim.
