Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> AW: :Oracle
Hi again
Ok. Next try: DBD::Oracle 1.15 doesn't seem to work, even with a = unix.rgs file (the version is identified, though).
So I got DBD::Oracle 1.12, 1.13 and 1.14. 1.14 doesn't work at all, 1.12 = and 1.13 could be compiled with no errors.
Results for configuring 1.14 looked like this:
$ perl Makefile.PL
Using DBI 1.40 (for perl 5.008002 on cygwin-thread-multi-64int) =
installed in =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file! Especially if you have any problems.
Using Oracle in c:/oracle/ora9
Found header files in rdbms/demo.
Found oci directory
Using OCI directory 'oci'
System: perl5.008002 cygwin_nt-5.0 troubardix 1.5.5(0.9432) 2003-09-20 =
16:31 i686 unknown unknown cygwin
Compiler: gcc -O2 -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing
Linker: /usr/bin/ld
Sysliblist:
Warning: If you have problems you may need to rebuild perl with = -Uusemymalloc.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=3Dc:/oracle/ora9/lib:c:/oracle/ora9/rdbms/lib
Using DBD::Oracle 1.13.
Using DBD::Oracle 1.13.
Using DBI 1.40 (for perl 5.008002 on cygwin-thread-multi-64int) =
installed in =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI
Writing Makefile for DBD::Oracle
*************************************************************************= ***************************************
.... make worked, make test gave me:
$ make test
/usr/bin/perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0, =
'blib/lib', 'blib/arch')" t/*.t
t/base.......ok t/cursor.....ok t/general....ok t/long.......ok t/ph_type....ok 3/19 expected 'trailing' but got 'trailing ' for =VARCHAR2
Failed 1/19 tests, 94.74% okay
t/plsql......ok
t/reauth.....skipped
all skipped: no reason given
t/select.....ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------= ------ t/ph_type.t 19 1 5.26% 121 test skipped.
*************************************************************************= ***************************************
... oh well .... make install ...
$ make install
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBD/Oracle/=
dbdimp.h
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBD/Oracle/=
libOracle.dll.a
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBD/Oracle/=
mk.pm
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBD/Oracle/=
ocitrace.h
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBD/Oracle/=
Oracle.bs
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBD/Oracle/=
Oracle.dll
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBD/Oracle/=
Oracle.h
Files found in blib/arch: installing files in blib/lib into architecture =
dependent library tree
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/oraperl.ph
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/Oraperl.pm
Installing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/DBD/Oracle.pm
Installing /usr/bin/ora_explain
Writing =
/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBD/Oracle/=
.packlist
Appending installation info to =
/usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/perllocal.pod
*************************************************************************= ***************************************
... and using Jared's cygwinDBI.pl (by the way, there's a "my" missing = at: >>my<< $underline =3D '=3D' x ($msg_len + 6);)
$ perl ~/perl/cygwinDBI.pl
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
|| || || 05.05.2004 13:46:56 Hello Cygwin DBI! :-) || || ||=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
.... seems to work. Happy hacking.
My environment:=20
$ uname -an
CYGWIN_NT-5.0 BOVSJA 1.5.5(0.94/3/2) 2003-09-20 16:31 i686 unknown =
unknown Cygwin
... plus=20
$ perl -version
This is perl, v5.8.2 built for cygwin-thread-multi-64int
Copyright 1987-2003, Larry Wall
... blahblahblah.
... plus
DBI 1.40 ... plus
SQL> select * from v$version;
BANNER
Hope it'll work for you, too.
Cheers,
Stefan
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Tel.: +49 201/45 13-298
Fax: +49 201/45 13-144
mailto:stefan.jahnke_at_nospam.bov.de
Please remove nospam to contact me via email.
http://www.bov.de
Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
Optimieren Sie durch Portale Ihr taegliches Geschaeft: Wie Anwendungen = in einem dynamischen Prozesskontext Ihre Informationsprozesse deutlich = beschleunigen koennen, erfahren Sie von mailto:martin.ostrowski_at_bov.de
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht = unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde = bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz = die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und = Aeusserungen ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be = copied or manipulated by third parties. For this reason we would ask for = your understanding that, for your own protection and ours, we must = decline all legal responsibility for the validity of the statements and = comments given above.
-----Urspr=FCngliche Nachricht-----
Von: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]Im Auftrag von Mladen Gogala
Gesendet: Monday, May 03, 2004 10:57 PM
An: Multiple recipients of list ORACLE-L
Betreff: DBD::Oracle
Has anybody been successful with building DBD::Oracle under Cygwin =
environment?
DBI-1.42 wasn't making any problems, but I couldn't build DBD::Oracle =
client with
neither 10g client nor with the 9.2 client. Any tips/tricks would be =
extremly helpful.
--=20
Mladen Gogala
Oracle DBA
Note:
This message is for the named person's use only. It may contain =
confidential, proprietary or legally privileged information. No =
confidentiality or privilege is waived or lost by any mistransmission. =
If you receive this message in error, please immediately delete it and =
all copies of it from your system, destroy any hard copies of it and =
notify the sender. You must not, directly or indirectly, use, disclose, =
distribute, print, or copy any part of this message if you are not the =
intended recipient. Wang Trading LLC and any of its subsidiaries each =
reserve the right to monitor all e-mail communications through its =
networks.
Any views expressed in this message are those of the individual sender, =
except where the message states otherwise and the sender is authorized =
to state them to be the views of any such entity.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed May 05 2004 - 06:53:02 CDT