DBD::Oracle and 10g

Hi,

I have 10g client installed under linux,
DBI version 1.50, DBD::Oracle module 1.16.

The make runs fine for DBD::Oracle but the "make test"
failed.

t/10general.............DBI connect('','/@',...) failed: ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.) at t/10general.t line 12
Undefined subroutine &main::BAILOUT called at t/10general.t line 15.
# Looks like your test died before it could output anything.

I think my environment is ok(NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15,
ORACLE_HOME is set). I can use sqlplus.

Looking around I found some hints about using a somewhat newer Makefile.PL ?

Any experience ?

Thomas


--

Re: DBD::Oracle and 10g

Yes there is a newer Makfile.pl You might want to try that.

One other quick suggestion id to set

NLS_LANG=WE8ISO8859P15

This is the the value I have used sucessfully in the past.


"Thomas Porschberg" wrote in message
news:20060110125354.GQ20782@porschberg.osp-dd.de...
> Hi,
>
> I have 10g client installed under linux,
> DBI version 1.50, DBD::Oracle module 1.16.
>
> The make runs fine for DBD::Oracle but the "make test"
> failed.
>
> t/10general.............DBI
connect('','/@',...) failed: ERROR
OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.) at t/10general.t
line 12
> Undefined subroutine &main::BAILOUT called at t/10general.t line 15.
> # Looks like your test died before it could output anything.
>
> I think my environment is ok(NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15,
> ORACLE_HOME is set). I can use sqlplus.
>
> Looking around I found some hints about using a somewhat newer Makefile.PL
?
>
> Any experience ?
>
> Thomas
>
>
> --
>

Re: DBD::Oracle and 10g

Thanks for your reply !

On Tue, Jan 10, 2006 at 10:09:08AM -0500, John Scoles wrote:
> Yes there is a newer Makfile.pl You might want to try that.

I used a newer one. But the same result. Compilation is ok,
but the tests fail.
>
> One other quick suggestion id to set
>
> NLS_LANG=WE8ISO8859P15

same story.

I really appreciated the instant client, but this is a bad news. :-(

>
> This is the the value I have used sucessfully in the past.
>
>
> "Thomas Porschberg" wrote in message
> news:20060110125354.GQ20782@porschberg.osp-dd.de...
> > Hi,
> >
> > I have 10g client installed under linux,
> > DBI version 1.50, DBD::Oracle module 1.16.
> >
> > The make runs fine for DBD::Oracle but the "make test"
> > failed.
> >
> > t/10general.............DBI
> connect('','/@',...) failed: ERROR
> OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.) at t/10general.t
> line 12
> > Undefined subroutine &main::BAILOUT called at t/10general.t line 15.
> > # Looks like your test died before it could output anything.
> >
> > I think my environment is ok(NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15,
> > ORACLE_HOME is set). I can use sqlplus.
> >
> > Looking around I found some hints about using a somewhat newer Makefile.PL
> ?
> >
> > Any experience ?
> >
> > Thomas
> >
> >
> > --
> >
>
>

--

Re: DBD::Oracle and 10g

Thomas Porschberg Wrote

>Thanks for your reply !

>On Tue, Jan 10, 2006 at 10:09:08AM -0500, John Scoles wrote:
> Yes there is a newer Makfile.pl You might want to try that.

>I used a newer one. But the same result. Compilation is ok,
>but the tests fail.
>
> One other quick suggestion id to set
>
> NLS_LANG=WE8ISO8859P15

>same story.

>I really appreciated the instant client, but this is a bad news. :-(

>

Is it the the Intant client you are using? and if you are wich version
10.2.0.1 or 10.1.0.4.

RE: DBD::Oracle and 10g

> Yes there is a newer Makfile.pl You might want to try that.
>
> One other quick suggestion id to set
>
> NLS_LANG=WE8ISO8859P15
>
> This is the the value I have used sucessfully in the past.

Presumably you mean

NLS_LANG=.WE8ISO8859P15

The leading "." is required (to skip the language and territory options).

andyh@testbox ~ $ export NLS_LANG=WE8ISO8859P15
andyh@testbox ~ $ echo exit | sqlplus -L -S test/test@test102
ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified


SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
andyh@testbox ~ $ export NLS_LANG=.WE8ISO8859P15
andyh@testbox ~ $ echo exit | sqlplus -L -S test/test@test102
andyh@testbox ~ $

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Re: DBD::Oracle and 10g

On Tue, Jan 10, 2006 at 02:17:37PM -0500, John Scoles wrote:
> Thomas Porschberg Wrote
>
> >Thanks for your reply !
>
> >On Tue, Jan 10, 2006 at 10:09:08AM -0500, John Scoles wrote:
> > Yes there is a newer Makfile.pl You might want to try that.
>
> >I used a newer one. But the same result. Compilation is ok,
> >but the tests fail.
> >
> > One other quick suggestion id to set
> >
> > NLS_LANG=WE8ISO8859P15
>
> >same story.
>
> >I really appreciated the instant client, but this is a bad news. :-(
>
> >
>
> Is it the the Intant client you are using? and if you are wich version
> 10.2.0.1 or 10.1.0.4.
>
You are right. Instant client.
The tip with the different versions was really good.
I upgraded from 10.1.0.4 to 10.2.0.1 and DBD::Oracle works now !

>
>

--

Re: DBD::Oracle and 10g

Opps me bad typo in the cut and paste. I hate computers. Yest the '.' is
needed.

""Andy Hassall"" wrote in message
news:20060110200608.IGWG19063.aamta11-winn.ispmail.ntl.com@e xcession...
> > Yes there is a newer Makfile.pl You might want to try that.
> >
> > One other quick suggestion id to set
> >
> > NLS_LANG=WE8ISO8859P15
> >
> > This is the the value I have used sucessfully in the past.
>
> Presumably you mean
>
> NLS_LANG=.WE8ISO8859P15
>
> The leading "." is required (to skip the language and territory options).
>
> andyh@testbox ~ $ export NLS_LANG=WE8ISO8859P15
> andyh@testbox ~ $ echo exit | sqlplus -L -S test/test@test102
> ERROR:
> ORA-12705: Cannot access NLS data files or invalid environment specified
>
>
> SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
> andyh@testbox ~ $ export NLS_LANG=.WE8ISO8859P15
> andyh@testbox ~ $ echo exit | sqlplus -L -S test/test@test102
> andyh@testbox ~ $
>
> --
> Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
>