You need the DBD::Oracle 1.12 build, it fixed my problems ;) It should be on the mirrors by now... -john >From: Mark Borges <mdb@jimi.nwest.attws.com> >Reply-To: mdb@jimi.nwest.attws.com >To: dbi-users@perl.org >CC: Tim.Bunce@pobox.com >Subject: DBD::Oracle-1.10 build problem with Oracle-8.1.7 >Date: 31 Aug 2001 11:21:45 -0700 > >[ I'm not on the mailing list, so I apologize if this is already a known > reported problem. Also, if this is insufficient information please > let me know and I can supply a full verbose report as directed in > the README. ] > >Attempting to build DBD::Oracle-1.10 under Solaris-2.6 and >Oracle-8.1.7, I encountered the following compilation error: > > oci8.c: In function `oci_hdtype_name': > oci8.c:118: `OCI_DTYPE_DATETIME' undeclared (first use in this function) > oci8.c:118: (Each undeclared identifier is reported only once > oci8.c:118: for each function it appears in.) > oci8.c:119: `OCI_DTYPE_INTERVAL' undeclared (first use in this function) > make: *** [oci8.o] Error 1 > >These are not defined in my 8.1.7's copy of .../rdbms/demo/oci.h, >but similar data types (OCI_DTYPE_DATE, OCI_DTYPE_TIME, etc.) are. > >Here is the relevant excerpt from oci.h: > > /*-------------------------Descriptor >Types----------------------------------*/ > /* descriptor values range from 50 - >255 */ > #define OCI_DTYPE_FIRST 50 /* start value of descriptor >type */ > #define OCI_DTYPE_LOB 50 /* lob >locator */ > #define OCI_DTYPE_SNAP 51 /* snapshot >descriptor */ > #define OCI_DTYPE_RSET 52 /* result set >descriptor */ > #define OCI_DTYPE_PARAM 53 /* a parameter descriptor obtained from >ocigparm */ > #define OCI_DTYPE_ROWID 54 /* rowid >descriptor */ > #define OCI_DTYPE_COMPLEXOBJECTCOMP 55 > /* complex object retrieval >descriptor */ > #define OCI_DTYPE_FILE 56 /* File Lob >locator */ > #define OCI_DTYPE_AQENQ_OPTIONS 57 /* enqueue >options */ > #define OCI_DTYPE_AQDEQ_OPTIONS 58 /* dequeue >options */ > #define OCI_DTYPE_AQMSG_PROPERTIES 59 /* message >properties */ > #define OCI_DTYPE_AQAGENT 60 /* aq >agent */ > #define OCI_DTYPE_LOCATOR 61 /* LOB >locator */ > #define OCI_DTYPE_INTERVAL_YM 62 /* Interval year month >*/ > #define OCI_DTYPE_INTERVAL_DS 63 /* Interval day second >*/ > #define OCI_DTYPE_AQNFY_DESCRIPTOR 64 /* AQ notify >descriptor */ > #define OCI_DTYPE_DATE 65 /* Date */ > #define OCI_DTYPE_TIME 66 /* Time */ > #define OCI_DTYPE_TIME_TZ 67 /* Time with >timezone */ > #define OCI_DTYPE_TIMESTAMP 68 /* Timestamp */ > #define OCI_DTYPE_TIMESTAMP_TZ 69 /* Timestamp with >timezone */ > #define OCI_DTYPE_TIMESTAMP_LTZ 70 /* Timestamp with local tz >*/ > #define OCI_DTYPE_UCB 71 /* user callback >descriptor */ > #define OCI_DTYPE_LAST 71 /* last value of a descriptor >type */ > >/*---------------------------------------------------------------------------*/ > > >The appended patch works for me, but is probably not correct in >general for all versions of Oracle8i. > >========== begin patch ========== >$ diff -u oci8.c.orig oci8.c >--- oci8.c.orig Thu Aug 30 08:48:47 2001 >+++ oci8.c Fri Aug 31 11:09:27 2001 >@@ -115,8 +115,16 @@ > case OCI_DTYPE_AQMSG_PROPERTIES: return >"OCI_DTYPE_AQMSG_PROPERTIES"; > case OCI_DTYPE_AQAGENT: return "OCI_DTYPE_AQAGENT"; > case OCI_DTYPE_LOCATOR: return "OCI_DTYPE_LOCATOR"; >- case OCI_DTYPE_DATETIME: return "OCI_DTYPE_DATETIME"; >- case OCI_DTYPE_INTERVAL: return "OCI_DTYPE_INTERVAL"; >+ /* case OCI_DTYPE_DATETIME: return >"OCI_DTYPE_DATETIME"; >+ case OCI_DTYPE_INTERVAL: return >"OCI_DTYPE_INTERVAL"; >+ */ >+ case OCI_DTYPE_DATE: return "OCI_DTYPE_DATE"; >+ case OCI_DTYPE_TIME: return "OCI_DTYPE_TIME"; >+ case OCI_DTYPE_TIME_TZ: return "OCI_DTYPE_TIME_TZ"; >+ case OCI_DTYPE_TIMESTAMP: return "OCI_DTYPE_TIMESTAMP"; >+ case OCI_DTYPE_TIMESTAMP_TZ: return "OCI_DTYPE_TIMESTAMP_TZ"; >+ case OCI_DTYPE_INTERVAL_YM: return >"OCI_DTYPE_INTERVAL_YM"; >+ case OCI_DTYPE_INTERVAL_DS: return >"OCI_DTYPE_INTERVAL_DS"; > case OCI_DTYPE_AQNFY_DESCRIPTOR: return >"OCI_DTYPE_AQNFY_DESCRIPTOR"; > } > sv = sv_2mortal(newSViv(hdtype)); >========== end patch ========== _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.aspThread Previous