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

***  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 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: