After DBD::Oracle has been built against a specific version of Oracle
it should continue to be used with that version. So at least ORACLE_HOME
LD_LIBRARY_PATH should be as they were. If you need to support multiple
Oracle installations then it's safest to use multiple DBD::Oracle installations.
Tim.
On Mon, Nov 25, 2002 at 12:31:15PM -0600, Friday, Ken wrote:
> Hi,
>
> Please forgive the quality of this post. I'm new to Perl, DBI and this list server.
>
> I'm working in an Oracle Apps v11.03, partitioned environment. The database is v
>8.1.6, the application tier is using v 8.0.6. The application tier account owns the
>batch scheduling mechanism.
>
> As the database account I'm able to run the code below and successfully connect to
>databases on both local and remote servers.
>
> As the application tier owner I receive the following error:
>
> DBI->connect(voyagerERP4) failed: ERROR OCIEnvInit at ./dbtest.pl line 5
> Can't connect to Oracle database: ERROR OCIEnvInit
>
> Note that I have no problems connecting to these databases via sqlplus foo/bar@<SID>
>
> I (think) I understand that this is a function of the invoking environment and have
>been modifying:
>
> ORACLE_HOME
> PATH
> LD_LIBRARY_PATH
> TWO_TASK
>
> But, I can't seem to figure out the specific variables impacting the script. Has
>anyone experienced this ?
>
>
> #!/bin/perl -w
> use DBI;
> my $db = $ARGV[0];
>
> my $dbh = DBI->connect( "dbi:Oracle:$db", "foo", "bar" )
> or die "Can't connect to Oracle database: $DBI::errstr\n";
> my $stamt = $dbh->prepare("select name from v\$database");
> $stamt->execute();
> my @name = $stamt->fetchrow_array();
> print @name, "\n";
> $stamt->finish;
> $dbh->disconnect
> or warn "Disconnection failed: $DBI::errstr\n";
>
> Thanks
> Ken Friday
> Artesyn Communication Products
> 8310 Excelsior Dr.
> Madison, WI 53717
> 608.826.8229
> [EMAIL PROTECTED]
>
