UNIX for Dummies Questions & Answers

hi,

i am new to perl:

os : Linux

i wrote simple perl script to select from table i am getting this error and how to set ORACLE_HOME environment variable :

script:

#!usr/bin/perl
use DBI;
use Mail::Sendmail;
#use Date::Calc;
use MIME::QuotedPrint;
use HTML::Entities;
use POSIX qw(strftime);

$dbhpindb= DBI->connect("dbi:Oracle:host=172.16.1.23;sid=pindb", "pin", "pin") or die "Unable to connect: $DBI::errstr";

$query="select * from prakash";
$sth = $dbhpindb->prepare($query);
$sth->execute() || die "Error in execute";
$sth->finish;
$dbhpindb->disconnect;

error i am getting:

[it@surapp02 DailyMail]$ perl testperl.pl
ORACLE_HOME environment variable not set!

Thanks

Prakash

ORACLE_HOME points to the directory where Oracle is installed.

prakash.gr,

How about setting your ORACLE_HOME to your script os set the ORACLE_HOME first before executing your script.

Cheers!