You need the DBD::Oracle 1.12 build, it fixed my problems ;)
It should be on the mirrors by now...
-john
>From: Mark Borges <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>CC: [EMAIL PROTECTED]
>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.asp
