Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sources.redhat.com/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
To:	cygwin AT cygwin DOT com
Subject:	Re: Exim, .forward and DBD::Oracle
Reply-To:	Harald Maier <maierh AT myself DOT com>
References:	<Pine DOT GSO DOT 4 DOT 44 DOT 0304132222120 DOT 26381-100000 AT slinky DOT cs DOT nyu DOT edu>
From:	Harald DOT Maier DOT BW AT t-online DOT de
Date:	Mon, 14 Apr 2003 07:28:54 +0200
In-Reply-To:	<Pine.GSO.4.44.0304132222120.26381-100000@slinky.cs.nyu.edu> (Igor
	Pechtchanski's message of "Sun, 13 Apr 2003 22:29:14 -0400 (EDT)")
Message-ID:	<u65phmyuh.fsf@myself.com>
User-Agent:	Gnus/5.090018 (Oort Gnus v0.18) Emacs/21.3 (windows-nt)
MIME-Version:	1.0
X-Sender:	320041125923-0001 AT t-dialin DOT net

Igor Pechtchanski <pechtcha AT cs DOT nyu DOT edu> writes:

> On Mon, 14 Apr 2003, Greg Matheson wrote:
>
>> On Sun, 13 Apr 2003, Dmitry Melekhov wrote:
>>
>> > Another problem is with perl in cygwin.  On Linux I can set
>> > $ENV{PATH} and $ENV{ORACLE_HOME} inside perl script, but in
>> > cygwin I had to write shell script to call perl script:

>> Does it work in Linux if you DON'T set $ENV{PATH} and
>> $ENV{ORACLE_HOME} inside your program? Are you sure they are not
>> set elsewhere in your environment?

> You know, Greg, I think you may have gotten it.  Is it possible that
> Perl interprets the "use" statements before the rest of the code,
> and the DBI module tries to load the appropriate DLL in its
> initialization?  Any code that sets the environment variables will
> not have been executed at that point.

Something is really different on Linux and CYGWIN. For example here I
am using an ORACLE_HOME that really don't exist:

,----[ Cygwin ]
| $ ORACLE_HOME=abc TWO_TASK=first ./dbi-test.pl
| Could not connect to first,
| (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS
|   settings etc. at ./dbi-test.pl line 14.
`----

,----[ GNU/Linux ]
| $ ORACLE_HOME=abc TWO_TASK=first ./dbi-test.pl
| SMITH
| ALLEN
| WARD
| ...
`----

On Cygwin it fails and under Linux it works !!!  It looks that the
Linux DBD::Oracle module use an additional fallback method. If
ORACLE_HOME is not valid then it tries again with the ORACLE_HOME
variable at compile time. Under CYGWIN this might not work because of
the DOS Syntax of the ORACLE_HOME (h:/usr/oracle/9.2.0). I am using on
both systems perl-5.8.0 and DBD-Oracle-1.12.

Harald


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -