DBD::Oracle is the oracle interface for the DBI module. The reason tha +t I need to get 1.20 into my perl deployment follows from CPAN. I ha +ve oracle 8iR3 From version 1.25 onwards DBD::Oracle only support Oracle clients 9.2 +or greater. Support for ProC connections was dropped in 1.29. If you are still stuck with an older version of Oracle or its client y +ou might want to look at the table below. +---------------------+--------------------------------------------- +--------+ | | Oracle Version + | +---------------------+----+-------------+---------+------+--------+ +--------+ | DBD::Oracle Version | <8 | 8.0.3~8.0.6 | 8iR1~R2 | 8iR3 | 9i | + 9.2~11 | +---------------------+----+-------------+---------+------+--------+ +--------+ | 0.1~16 | Y | Y | Y | Y | Y | + Y | +---------------------+----+-------------+---------+------+--------+ +--------+ | 1.17 | Y | Y | Y | Y | Y | + Y | +---------------------+----+-------------+---------+------+--------+ +--------+ | 1.18 | N | N | N | Y | Y | + Y | +---------------------+----+-------------+---------+------+--------+ +--------+ | 1.19 | N | N | N | Y | Y | + Y | +---------------------+----+-------------+---------+------+--------+ +--------+ | 1.20 | N | N | N | Y | Y | + Y | +---------------------+----+-------------+---------+------+--------+ +--------+ | 1.21~1.24 | N | N | N | N | Y | + Y | +---------------------+----+-------------+---------+------+--------+ +--------+ | 1.25+ | N | N | N | N | N | + Y | +---------------------+----+-------------+---------+------+--------+ +--------+ As there are dozens of different versions of Oracle's clients this lis +t does not include all of them, just the major released versions of O +racle. My @INC is @INC: C:/Perl64/site/lib C:/Perl64/lib . I installed cpanm, but when I tried the uninstall it returned the foll +owing C:\sql> cpanm --uninstall DBD::Oracle ! DBD::Oracle is not found in the following directories and can't be u +ninstalled . C:\Perl64\site\lib C:\Perl64\site\lib When I ran the perl Makefile.PL and then dmake in the downloaded I get + the following C:\temp5\DBD-Oracle-1.20>perl Makefile.PL Multiple copies of Driver.xst found in: C:/Perl64/site/lib/auto/DBI/ C +:/Perl64/l ib/auto/DBI/ at Makefile.PL line 35. Using DBI 1.639 (for perl 5.024003 on MSWin32-x64-multi-thread) instal +led in C:/ Perl64/site/lib/auto/DBI/ Configuring DBD::Oracle for perl 5.024003 on MSWin32 (MSWin32-x64-mult +i-thread) Remember to actually *READ* the README file! Especially if you have an +y problems . Using Oracle in C:/app/Oracle12c/product/12.2.0/dbhome_1 DEFINE _SQLPLUS_RELEASE = "1202000100" (CHAR) Oracle version 12.2.0.1 (12.2) Found oci directory Using OCI directory 'oci' Checking for functioning wait.ph System: perl5.024003 Compiler: C:\Perl64\site\bin\gcc.exe -s -O2 -s -O2 -DWIN32 -DWIN64 +-DCONSERVA TIVE -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTE +XT -DPERL_ IMPLICIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields Linker: not found Sysliblist: Checking if your kit is complete... Looks good Warning (mostly harmless): No library found for -lmoldname Warning (mostly harmless): No library found for -lkernel32 Warning (mostly harmless): No library found for -luser32 Warning (mostly harmless): No library found for -lgdi32 Warning (mostly harmless): No library found for -lwinspool Warning (mostly harmless): No library found for -lcomdlg32 Warning (mostly harmless): No library found for -ladvapi32 Warning (mostly harmless): No library found for -lshell32 Warning (mostly harmless): No library found for -lole32 Warning (mostly harmless): No library found for -loleaut32 Warning (mostly harmless): No library found for -lnetapi32 Warning (mostly harmless): No library found for -luuid Warning (mostly harmless): No library found for -lws2_32 Warning (mostly harmless): No library found for -lmpr Warning (mostly harmless): No library found for -lwinmm Warning (mostly harmless): No library found for -lversion Warning (mostly harmless): No library found for -lodbc32 Warning (mostly harmless): No library found for -lodbccp32 Warning (mostly harmless): No library found for -lcomctl32 LD_RUN_PATH=C:/app/Oracle12c/product/12.2.0/dbhome_1/lib:C:/app/Oracle +12c/produc t/12.2.0/dbhome_1/rdbms/lib Using DBD::Oracle 1.20. Using DBD::Oracle 1.20. Multiple copies of Driver.xst found in: C:/Perl64/site/lib/auto/DBI/ C +:/Perl64/l ib/auto/DBI/ at Makefile.PL line 1657. Using DBI 1.639 (for perl 5.024003 on MSWin32-x64-multi-thread) instal +led in C:/ Perl64/site/lib/auto/DBI/ Generating a dmake-style Makefile Writing Makefile for DBD::Oracle Writing MYMETA.yml and MYMETA.json *** If you have problems... read all the log printed above, and the README and README.help.tx +t files. (Of course, you have read README by now anyway, haven't you?) C:\temp5\DBD-Oracle-1.20>dmake cp lib/DBD/Oracle/GetInfo.pm blib\lib\DBD\Oracle\GetInfo.pm cp oraperl.ph blib\lib/oraperl.ph cp ocitrace.h blib\arch\auto\DBD\Oracle/ocitrace.h cp Oracle.h blib\arch\auto\DBD\Oracle/Oracle.h cp Oraperl.pm blib\lib/Oraperl.pm cp mk.pm blib\arch\auto\DBD\Oracle/mk.pm cp mkta.pl blib\lib\DBD\mkta.pl cp dbdimp.h blib\arch\auto\DBD\Oracle/dbdimp.h cp Oracle.pm blib\lib\DBD\Oracle.pm Running Mkbootstrap for Oracle () "C:\Perl64\bin\perl.exe" -MExtUtils::Command -e chmod -- 644 "Oracle.b +s" "C:\Perl64\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- Ora +cle.bs bli b\arch\auto\DBD\Oracle\Oracle.bs 644 "C:\Perl64\bin\perl.exe" -p -e "s/~DRIVER~/Oracle/g" C:\Perl64\site\li +b\auto\DBI \Driver.xst > Oracle.xsi "C:\Perl64\bin\perl.exe" "C:\Perl64\lib\ExtUtils\xsubpp" -typemap C:\ +Perl64\lib \ExtUtils\typemap -typemap C:\temp5\DBD-Oracle-1.20\typemap Oracle.xs + > Oracle. xsc "C:\Perl64\bin\perl.exe" -MExtUtils::Command -e mv -- Oracle.xsc Oracl +e.c C:\Perl64\site\bin\gcc.exe -c -IC:/app/Oracle12c/product/12.2.0/dbhom +e_1/oci/in clude -IC:/app/Oracle12c/product/12.2.0/dbhome_1/rdbms/demo -IC:\Perl6 +4\site\lib \auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE -DPERL_TEXTMODE_ +SCRIPTS -D USE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fwrapv +-fno-stric t-aliasing -mms-bitfields -s -O2 -DVERSION=\"1.20\" -DXS_V +ERSION=\"1 .20\" "-IC:\Perl64\lib\CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW +_OCI_INIT -DORA_OCI_VERSION=\"12.2.0.1\" Oracle.c Oracle.c: In function 'XS_DBD__Oracle__st_ora_execute_array': Oracle.c:1535:14: error: 'sv_undef' undeclared (first use in this func +tion) Oracle.c:1535:14: note: each undeclared identifier is reported only on +ce for eac h function it appears in Oracle.xs: In function 'XS_DBD__Oracle__st_cancel': Oracle.xs:154:44: error: 'sv_yes' undeclared (first use in this functi +on) Oracle.xs:154:54: error: 'sv_no' undeclared (first use in this functio +n) Oracle.xs: In function 'XS_DBD__Oracle__db_reauthenticate': Oracle.xs:166:62: error: 'sv_yes' undeclared (first use in this functi +on) Oracle.xs:166:72: error: 'sv_no' undeclared (first use in this functio +n) Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_write': Oracle.xs:194:11: error: 'sv_undef' undeclared (first use in this func +tion) Oracle.xs:219:11: error: 'sv_yes' undeclared (first use in this functi +on) Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_append': Oracle.xs:250:11: error: 'sv_undef' undeclared (first use in this func +tion) Oracle.xs:274:17: error: 'sv_yes' undeclared (first use in this functi +on) Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_read': Oracle.xs:330:13: error: 'sv_undef' undeclared (first use in this func +tion) Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_trim': Oracle.xs:362:11: error: 'sv_undef' undeclared (first use in this func +tion) Oracle.xs:365:11: error: 'sv_yes' undeclared (first use in this functi +on) Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_length': Oracle.xs:380:11: error: 'sv_undef' undeclared (first use in this func +tion) dmake.exe: Error code 129, while making 'Oracle.o' C:\temp5\DBD-Oracle-1.20>
In reply to Re^2: HOW CAN i DOWNGRADE DBD::Oracle
by BillB
in thread HOW CAN i DOWNGRADE DBD::Oracle
by BillB
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |