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

Home -> Community -> Mailing Lists -> Oracle-L -> AW: :Oracle

AW: :Oracle

From: Stefan Jahnke <Stefan.Jahnke_at_bov.de>
Date: Wed, 5 May 2004 13:55:59 +0200
Message-ID: <87F172BCF111D0489340AB3CB16A011E5CE6B8@EBMS20.bov.int>


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
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_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.



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
-----------------------------------------------------------------
----------------------------------------------------------------
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

Original text of this message

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