Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBD::Oracle for Oracle8

DBD::Oracle for Oracle8

From: Ron Reidy <rreidy_at_skyconnect.com>
Date: Tue, 4 May 1999 08:16:48 -0600
Message-ID: <7gmvge$jgr$1@news1.rmi.net>


Hi,

I am trying desperately to get DBD/DBI installed.

Here is my config:

Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:   Platform:
    osname=dec_osf, osvers=4.0, archname=alpha-dec_osf     uname='osf1 <computer_name> v4.0 878 alpha '     hint=recommended, useposix=true, d_sigaction=define     usethreads=undef useperlio=undef d_sfio=undef   Compiler:
    cc='cc', optimize='-O4', gccversion=     cppflags='-std -ieee -D_INTRINSICS -DLANGUAGE_C'     ccflags ='-std -fprm d -ieee -D_INTRINSICS -DLANGUAGE_C'     stdchar='unsigned char', d_stdstdio=define, usevfork=false     intsize=4, longsize=8, ptrsize=8, doublesize=8     d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8     alignbytes=8, usemymalloc=y, prototype=define   Linker and Libraries:
    ld='ld', ldflags =''
    libpth=/usr/shlib /usr/ccs/lib /usr/lib/cmplrs/cc /usr/lib /var/shlib     libs=-ldbm -ldb -lm
    libc=/usr/shlib/libc.so, so=so, useshrplib=true, libperl=libperl.so   Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, cdlflags=' -Wl,-rpath,/usr/local/lib/perl5/5.00503/alpha-dec_osf/CORE'

    cccdlflags=' ', lddlflags='-shared -expect_unresolved "*" -O4 -msym -s'

Characteristics of this binary (from libperl):   Built under dec_osf
  Compiled at Apr 26 1999 10:45:48
  @INC:

    /usr/local/lib/perl5/5.00503/alpha-dec_osf
    /usr/local/lib/perl5/5.00503
    /usr/local/lib/perl5/site_perl/5.005/alpha-dec_osf
    /usr/local/lib/perl5/site_perl/5.005
    .

I have already compiled and installed DBI v 1.06

Here is the output of "perl Makefile.PL -p"

Using DBI 1.06 installed in
/usr/local/lib/perl5/site_perl/5.005/alpha-dec_osf/auto/DBI

Configuring DBD::Oracle ...

>>> Remember to actually *READ* the README file!

    Especially if you have any problems.

Using Oracle in /usr/oracle8/product

8.0.5.0.0            ORACLE Common RDBMS Libraries and Utilities
8.0.5.0.0            ORACLE PL/SQL Libraries
8.0.5.0.0            ORACLE Common Precomp Libraries
8.0.5.1.0            PL/SQL
8.0.5.1.0            Oracle8 (RDBMS and PL/SQL)
8.0.5.1.0            Precomp
8.0.5.1.0            Pro*C/C++

Found /usr/oracle8/product/precomp/demo/proc/demo_proc.mk
Found /usr/oracle8/product/rdbms/demo/demo_rdbms.mk Using /usr/oracle8/product/precomp/demo/proc/demo_proc.mk Reading /usr/oracle8/product/precomp/demo/proc/demo_proc.mk. Reading /usr/oracle8/product/precomp/lib/env_precomp.mk. Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/   because it is not already set in the environment   and it can cause ORA-01019 errors.
Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/   because it is not already set in the environment   and it can cause ORA-01019 errors.
Found header files in rdbms/demo.

System: perl5.00503 osf1 xxx v4.0 878 alpha Compiler: cc -O4 -std -fprm d -ieee -D_INTRINSICS -DLANGUAGE_C Linker: /usr/bin/ld
Oracle makefiles would have used these values but we override them:   CC: cc
  CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -O4 -fast -fp_reorder -U_FASTMATH -O4 -fast -fp_reorder -U_FASTMAT H $(GEMC_FLAGS) -std1 -DOSF1 -DA_OSF -Wf,-readonly_strings -D_INTRINSICS $(QACCFLAGS) -I. -I/usr/oracle8/product/precomp/public -I/usr/oracle8/produc t/rdbms/public -I/usr/oracle8/product/rdbms/demo -I/usr/oracle8/product/plsq l/public -I/usr/oracle8/product/network/public $(LPFLAGS) $(SHARED_CFLAG) $(USRFLAGS)]
  CLIBS: $(TTLIBS_QA) $(LDLIBS)
Evaluating `cat $(LIBHOME)sysliblist`
  expanded `cat /usr/oracle8/product/lib/sysliblist`   returned '-lexc -lmld -lrt -laio -lm'

           [$(TTLIBS_QA) $(EXPDLIBS) -lexc -lmld -lrt -laio -lm $(EXSYSLIBS) -lm $(USRLIBS)]
  LDFLAGS: $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) $(NO_STRIP_EXE?:-s)

           [$(CDEBUG?-O4 -fast -fp_reorder -U_FASTMATH:-O3) -o $@ -L$(LIBHOME) -s]

Linking with -lclntsh [from $(PROLDLIBS)]

Warning: By default new modules are installed into your 'site_lib' directories. Since site_lib directories come after the normal library directories you must delete any old DBD::Oracle files and directories from your 'privlib' and 'archlib' directories and their auto subdirectories.

Using DBD::Oracle 0.59.
Using DBI 1.06 installed in
/usr/local/lib/perl5/site_perl/5.005/alpha-dec_osf/auto/DBI
Writing Makefile for DBD::Oracle

Below is the output of the make command:

mkdir blib

mkdir blib/lib
mkdir blib/lib/DBD
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/DBD
mkdir blib/arch/auto/DBD/Oracle
mkdir blib/lib/auto
mkdir blib/lib/auto/DBD
mkdir blib/lib/auto/DBD/Oracle
mkdir blib/man1
mkdir blib/man3

cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
/usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
/usr/local/lib/perl5/site_perl/5.005/alpha-dec_osf/auto/DBI/Driver.xst >
Oracle.xsi
/usr/local/bin/perl -I/usr/local/lib/perl5/5.00503/alpha-dec_osf -I/usr/loca
l/lib/perl5/5.00503 /usr/local/lib/perl5/5.00503/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs >xstmp.c && mv
xstmp.c Oracle.c
cc -c -I. -I/usr/oracle8/product/precomp/public -I/usr/oracle8/product/rdbms
/public -I/usr/oracle8/product/rdbms/demo -I/usr/oracle8/product/plsql/publi
c -I/usr/oracle8/product/network/public -I/usr/oracle8/product/rdbms/demo -I
/usr/oracle8/product/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.005/alpha
-dec_osf/auto/DBI -std -fprm
eee -D_INTRINSICS -DLANGUAGE_C -O4 -DVERSION=\"0.59\" -DXS_VERSION=\"0. 59\" -I/usr/local/lib/perl5/5.00503/alpha-dec_osf/CORE Oracle.c cc -c -I. -I/usr/oracle8/product/precomp/public -I/usr/oracle8/product/rdbms
/public -I/usr/oracle8/product/rdbms/demo -I/usr/oracle8/product/plsql/publi
c -I/usr/oracle8/product/network/public -I/usr/oracle8/product/rdbms/demo -I
/usr/oracle8/product/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.005/alpha
-dec_osf/auto/DBI -std -fprm
eee -D_INTRINSICS -DLANGUAGE_C -O4 -DVERSION=\"0.59\" -DXS_VERSION=\"0. 59\" -I/usr/local/lib/perl5/5.00503/alpha-dec_osf/CORE dbdimp.c cc -c -I. -I/usr/oracle8/product/precomp/public -I/usr/oracle8/product/rdbms
/public -I/usr/oracle8/product/rdbms/demo -I/usr/oracle8/product/plsql/publi
c -I/usr/oracle8/product/network/public -I/usr/oracle8/product/rdbms/demo -I
/usr/oracle8/product/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.005/alpha
-dec_osf/auto/DBI -std -fprm
eee -D_INTRINSICS -DLANGUAGE_C -O4 -DVERSION=\"0.59\" -DXS_VERSION=\"0. 59\" -I/usr/local/lib/perl5/5.00503/alpha-dec_osf/CORE oci7.c cc -c -I. -I/usr/oracle8/product/precomp/public -I/usr/oracle8/product/rdbms
/public -I/usr/oracle8/product/rdbms/demo -I/usr/oracle8/product/plsql/publi
c -I/usr/oracle8/product/network/public -I/usr/oracle8/product/rdbms/demo -I
/usr/oracle8/product/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.005/alpha
-dec_osf/auto/DBI -std -fprm
eee -D_INTRINSICS -DLANGUAGE_C -O4 -DVERSION=\"0.59\" -DXS_VERSION=\"0. 59\" -I/usr/local/lib/perl5/5.00503/alpha-dec_osf/CORE oci8.c Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
ar cr tmp.a Oracle.o dbdimp.o oci7.o oci8.o : tmp.a
LD_RUN_PATH="/usr/oracle8/product/lib" ld -o blib/arch/auto/DBD/Oracle/Oracle.so -shared -expect_unresolved "*" -O4 -msym -s -all tmp.a -none -L/usr/oracle8/product/lib/ -lclntsh chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs mkdir blib/script
cp ora_explain blib/script/ora_explain
/usr/local/bin/perl -I/usr/local/lib/perl5/5.00503/alpha-dec_osf -I/usr/loca
l/lib/perl5/5.00503 -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man3/DBD::Oraperl.3
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1


Below is the output of "make test"

PERL_DL_NONLAZY=1
/usr/local/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.00503/al
pha-dec_osf -I/usr/local/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/base..............ok
t/general...........dubious
Test returned status 0 (wstat 139, 0x8b) Number found where operator expected at (eval 400) line 1, near ")0" (Missing operator before 0?)
Number found where operator expected at (eval 401) line 1, near ")1" (Missing operator before 1?)
Number found where operator expected at (eval 402) line 1, near ")2" (Missing operator before 2?)
Number found where operator expected at (eval 403) line 1, near ")3" (Missing operator before 3?)
test program seems to have generated a core after all the subtests completed successfully t/plsql.............ok
Failed Test Status Wstat Total Fail Failed List of failed



---
t/general.t 0 139 4 0 0.00% ?? Failed 1/3 test scripts, 66.67% okay. 0/58 subtests failed, 100.00% okay. *** Exit 2
Stop.

Can anyone give me some hint as to what is wrong? Am I using the incorrect DBI/DBD combination? Right now I will take anything that works.

Thanks for your help.

Ron Reidy Received on Tue May 04 1999 - 09:16:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US