AW: :Oracle
- From: "Stefan Jahnke" <Stefan.Jahnke@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 May 2004 13:55:59 +0200
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
*** If you have problems...
read all the log printed above, and the README and README.help =
files.
(Of course, you have read README by now anyway, haven't you?)
*************************************************************************=
***************************************
.... 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
t/ph_type....FAILED test 12
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% 12
1 test skipped.
Failed 1/8 test scripts, 87.50% okay. 1/300 subtests failed, 99.67% =
okay.
make: *** [test_dynamic] Error 14
*************************************************************************=
***************************************
... 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
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
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@xxxxxxxxxxxxx
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@xxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
