On Tue, 9 Sep 2003 12:50:07 -0400 "Sharma, Amit" <[EMAIL PROTECTED]> wrote:
> While trying to execute the following SQL , I get the following > error: > Can't call method "execute" on an undefined value at x.pl line 105. > .. > my $sqlSch = "SELECT SEQ_NO from $TableName"; > my $sth = $dbHandle->prepare($sqlSch); > $sth->execute(); > $sth->bind_columns(undef, \$SequenceNum); The prepare() failed and you haven't the foggiest notion of what happened since you aren't checking for errors. You should either set $dbHandle -> {RaiseError} or check for errors on each method call. # Either enable implicit error checking $dbHandle -> {RaiseError} = 1; # Or check for errors each method call my $sqlSch = "SELECT SEQ_NO from $TableName"; my $sth = $dbHandle->prepare($sqlSch) or die "Prepare failed, $DBI::errstr\n$sqlSch\n"; $sth->execute() or die "Execute failed, $DBI::errstr\n"; -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.