build of DBD-Oracle 1.15 not possible using Oracle 8.0.6

• Previous message: Mark Coleman: "Weird Oracle CLOB insert problem"
• Next in thread: Tim Bunce: "Re: build of DBD-Oracle 1.15 not possible using Oracle 8.0.6"
• Reply: Tim Bunce: "Re: build of DBD-Oracle 1.15 not possible using Oracle 8.0.6"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Fri, 28 May 2004 17:29:50 +0200
To: dbi-users@perl.org

Hi,

In the 'Changes in DBD-Oracle 1.15 27th January 2004' is written that:

        Fixed to build okay for Oracle 8.0.x and for older C compilers.

But DBD-Oracle 1.15 is not usable if it build using Oracle 8.0.6 libraries:

        Unresolved symbol: OCILobWriteAppend (code) from blib/arch/auto/DBD/Oracle/Oracle.sl

There is really no *.o, *.a and *.sl (HP-UX 10.20 => Oracle 8.0.6 last possible
release) in the Oracle 8.0.6 tree, which defines OCILobWriteAppend.

I have done the following changes:

--- Oracle.xs~ Wed Jan 28 00:44:50 2004
+++ Oracle.xs Thu May 27 18:16:48 2004
@@ -160,7 +160,7 @@
     amtp = data_len;
     /* if locator is CLOB and data is UTF8 and not in bytes pragma */
     /* if (0 && SvUTF8(data) && !IN_BYTES) { amtp = sv_len_utf8(data); } */
-#ifdef OCI_V8_SYNTAX
+#if defined(OCI_V8_SYNTAX) && defined(OCIFileInit)
     OCILobWriteAppend_log_stat(imp_dbh->svchp, imp_dbh->errhp, locator,
             &amtp, bufp, (ub4)data_len, OCI_ONE_PIECE,
             NULL, NULL,
--- t/long.t~ Wed Jan 28 00:45:18 2004
+++ t/long.t Thu May 27 18:43:33 2004
@@ -275,7 +275,7 @@
 
 
 
-if (ORA_OCI >= 8 && $type_name =~ /LOB/i) {
+if (ORA_OCI > 8 && $type_name =~ /LOB/i) {
     print " --- testing ora_auto_lob to access $type_name LobLocator\n";
     my $ll_sth = $dbh->prepare(qq{
             SELECT lng, idx FROM $table ORDER BY idx

Now it works, except the lob appending. The second patch was already necessary
for DBD-Oracle 1.12 and Oracle 8.0.6 (the server version is the same), because
otherwise some blob test failes and this stops be rpm (yes on HP-UX) build.
I don't know if defined(OCIFileInit) is a general good choice, but OCI_V8_SYNTAX
is defined in oci.h of Oracle 8.0.6 and 8.1.6 and has for both releases the
value 3. But 8.1.6 provides OCILobWriteAppend and 8.0.6 not.

BTW, it would be a good idea that Makefile.PL supports in the next release a
additional option. Currenty -l forces the usage of liblntsh.sl, the additional
option should force the usage of the static libclnt library (e.g. libclntst8.a).
On HP-UX 11.00 the liblntsh.sl of Oracle 8.1.6 is linked with libcl.2. This is not
necessary for DBD-Oracle but raises a incompatibly error if Oracle.sl is loaded
by a non threaded Perl 5.6.1 (but linked with libpthread). Using libclntst8.a all
works fine.

regards, Silvio

• Previous message: Mark Coleman: "Weird Oracle CLOB insert problem"
• Next in thread: Tim Bunce: "Re: build of DBD-Oracle 1.15 not possible using Oracle 8.0.6"
• Reply: Tim Bunce: "Re: build of DBD-Oracle 1.15 not possible using Oracle 8.0.6"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]