Re: Oracle connection issue with perl DBI

2007-12-19 Thread John D Groenveld
In message <[EMAIL PROTECTED]>, "Kumar Ranjan" writes: >I am facing a funny but troubling issue with Perl DBI & Oracle. >When my shell environment does not have ORACLE_HOME path set, my script >works fine. I am connecting >to Oracle DB like this: > >#!/usr/bin/perl -w >use strict; >use DBI; >my $d

Re: ORA-01406 from a perl script using DBI package

2007-12-19 Thread Alexander V Alekseev
Hello! Your script works just fine for me, with a small change (see below). On Mon, 17 Dec 2007, Grech, Raymond wrote: > Can anyone help me resolve this problem? > > > I am trying to print DDL statements using the DBI package in a perl script. > > > > I am getting thi

Oracle connection issue with perl DBI

2007-12-19 Thread Kumar Ranjan
Folks, I am facing a funny but troubling issue with Perl DBI & Oracle. When my shell environment does not have ORACLE_HOME path set, my script works fine. I am connecting to Oracle DB like this: #!/usr/bin/perl -w use strict; use DBI; my $dbh = DBI->connect("dbi:Oracle:host=xx.gold.com;port=1522;

RE: Environment variable problem?

2007-12-19 Thread John Scoles
Just a repost so other can learn from it Cheers Date: Wed, 19 Dec 2007 10:05:58 -0500From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Re: Environment variable problem?It wasn't permissions, I fixed it by adding my PATH to the crontab and now it works. Thanks for the help and enjoy the Holiday se