Ah, phooey. Sometimes I just hate Oracle. Oh well, just comment out those lines. I'll make a new release shortly. Tim. On Thu, Aug 30, 2001 at 07:16:10PM +0200, Jan Matejka wrote: > Hi, > > I found compilation problem on Windows 2000 (same on RedHat 6.2) with Oracle > 8.1.7 client: > > Oracle 8.1.5 client in file OCI.H has: > > /*-------------------------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_DATETIME 62 /* datetime structure > */ > #define OCI_DTYPE_INTERVAL 63 /* interval structure > */ > #define OCI_DTYPE_AQNFY_DESCRIPTOR 64 /* AQ notify descriptor */ > #define OCI_DTYPE_LAST 64 /* last value of a descriptor type > */ > > /*-------------------------------------------------------------------------- > -*/ > > but in Oracle 8.1.7 client in file OCI.H there are rather different values: > > /*-------------------------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 */ > /*-------------------------------------------------------------------------- > -*/and compilation of OCI8.C crashes with: > > > *** WINDOWS 2000 *** > > cl -c -IC:/oracle/ora817/oci/include -IC:/oracle/ora817/rdbms/demo -IC:/bin/ > Perl/site/lib/auto/DBI > -nologo -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT > -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DPERL_MSVCRT_READFIX -O1 > -MD -DNDEBUG -DVERSION=\"1.10\" -DXS_VERSION=\"1.10\" -IC:\bin\Perl\lib\ > CORE oci8.c > oci8.c > oci8.c(118) : error C2065: 'OCI_DTYPE_DATETIME' : undeclared identifier > oci8.c(118) : error C2051: case expression not constant > oci8.c(119) : error C2065: 'OCI_DTYPE_INTERVAL' : undeclared identifier > oci8.c(119) : error C2051: case expression not constant > > > *** Redhat 6.2 *** > > gcc -c -I/data/oracle/product/8.1.7/rdbms/demo -I/data/oracle/product/8.1.7/ > rdbms/public -I/data/oracle/product/8.1.7/plsql/public -I/data/oracle/produc > t/8.1.7/network/public -I/data/oracle/product/8.1.7/rdbms/demo -I/data/oracl > e/product/8.1.7/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux > /auto/DBI -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_F > ILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.10\" -DXS_VERSION=\"1.10\" -fpic -I/u > sr/local/lib/perl5/5.6.1/i686-linux/CORE oci8.c > 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 > > MaT > > > -----Original Message----- > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 30, 2001 6:31 PM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: ANNOUNCE: DBD::Oracle 1.10 > > > > > > file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.10.tar.gz > > size: 172728 bytes > > md5: ba1351819bbf9c3418f29c3636e92fbf > > > > Changes in DBD::Oracle 1.10 30th August 2001 > > > > Explicitly require DBI version 1.20 (or later). > > Support multiple oracle home's in Win32 registry thanks to > > Jeff Urlwin. > > Improved build support for Oracle >=8.1.7 (I_SYM) thanks to > > Stephen Close. > > Fixed LOB bug when writing non-string values thanks to > > Stephen Close. > > Fixed t/ph_type.t to be better behaved thanks to Ville Skytta. > > Added OCI8 handle/descriptor name to trace output for some > > API calls. > > > > Changes in DBD::Oracle 1.09 27th August 2001 > > > > Changed behaviour when OCIStmtExecute() returns > > OCI_SUCCESS_WITH_INFO: > > used to be treated as OCI_SUCCESS, now also sets > > $DBI::err/$DBI::errstr > > and will therefore trigger RaiseError/PrintError if they are set. > > Fixed ins/upd of LOBs in views thanks to Tom Moore. > > Fixed reading of CLOBs in wide characters sets. > > Fixed 'inherited AUTOLOAD for non-method > > DBD::Oracle::ORA_OCI' problem. > > Workaround very long column names causing failure thanks to > > Martin Busik. > > Added $dbh->primary_key_info() thanks to Steffen Goeldner. > > Added $sth->cancel method thanks to Fredrik Sjoholm. > > Added mention to registry to login failed hint thanks to > > Tim Callaghan. > > Changed type_info_all VARCHAR2 max length to 4000 if using OCI8. > > Removed use of perl global PL_no_modify to avoid linkage problems. > > Old OCI7 API: > > Fixed OCI7 memory leak from statement handles thanks to > > Bret Haeler. > > Fixed OCI7 PRECISION for RAW data types thanks to J.D. Laub. > > Fixed old OCI7 LONG buffer overwrite bug thanks to Bruce > > Templeton. > > (I thought I'd done this before but perhaps now it's > > done right.) > > Build: > > Fixed default build to set LD_RUN_PATH at build time. Yeah. > > Fixed parsing of Oracle's .mk files to handle += > > (appending values). > > Fixed detection of 'OCI' dire for Win32 Oracle >=8.1 > > thanks to many. > > Improved test for gcc in Makefile.PL thanks to Ian Kallen. > > Improved build rule detection thanks to Jonathan Segal. > > Don't merge text from Oracle's .mk into generated > > Makefile (use -f to reenable). > > Fixed bad test in plsql.t so shouldn't give false negatives. > > Added t/ph_type.t to test placeholder type issues thanks > > to James Jurach. > > Retested for perl 5.4.4 for possibly the last time. You > > have been warned. > > In future I'll only be testing on perl >= 5.5.3 and >=5.6.1. > > Documentation: > > Documented workaround for hang in "repetitive connect" > > test thanks to Alexi Lookin. > > Short version: add bequeath_detach=yes to sqlnet.ora file. > > Documented ora_oratab_orahome connect attribute (Oracle > > OCI 7 only). > > Documented ora_module_name connect attribute thanks to Renzo Toma. > > Added IRIX linking advice into README.help thanks to Dennis Box. > > Added AIX core dump on disconnect advice into README.help. > > Added docs on how Oracle determines the timezone thanks > > to Brad Howerter. > > Added 'return cursor function' example to docs thanks to > > Michael A. Chase > > Added more notes to README.java thanks to Peter Ludemann > > and Dave C. > > Added more notes to README.login thanks to Geoff Young. > > > > Enjoy! > > > > Tim. > > >
