TIMESTAMP will be supported in the next release. Thanks.
Tim. On Thu, May 29, 2003 at 04:45:23PM +0800, XIE,KE-XIAN (HP-China,ex2) wrote: > Hi bunce, > I have compiled your DBD::Oracle1.13 on HP-UX11i together with perl > 5.8.0 64bit, DBI 1.30 64bit. > When I use dbi to fetch the data typed of TIMESTAMP of Oracle9i, during > the prepare station, error > occurs that "data type 187 is not supported". > And I search the file oci8.c and dbdimp.c you provided. > Then I do some modification about them, re-compile them and then it can > fetch TIMESTAMP correctly. > **************************************************************************** > ************************************* > What I modified: > oci8.c: > Func: dbd_st_fetch(SV *sth, imp_sth_t *imp_sth) > Line: 1201 > Modification: > Add two more case statements: > ...... > case 187: /* TIMESTAMP */ > /* actually dependent on NLS default date format*/ > fbh->disize = 75; /* a generous default */ > break; > case 232: /* TIMESTAMP WITH LOCAL TIME ZONE*/ > /* actually dependent on NLS default date format*/ > fbh->disize = 75; /* a generous default */ > break; > ...... > > dbdimp.c: > Func: static sql_fbh_t ora2sql_type(imp_fbh_t* fbh) > Line: 2140 > Modification: > Add one more case statement: > ...... > case SQLT_TIMESTAMP: sql_fbh.dbtype = SQL_TIMESTAMP; break; > ...... > **************************************************************************** > ************************************* > I want to know if what I modified can be adopted or it can raise some other > risks? > > Thanks you very much!!! > > Best Regards, > Section Xie
