Hi, 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); ..
However, when I hard-code the value for the table name, as shown below, the script works fine. my $sqlSch = "SELECT SEQ_NO from Employee_data"; my $sth = $dbHandle->prepare($sqlSch); $sth->execute(); $sth->bind_columns(undef, \$SequenceNum); .. Am unable to figure out the problem. While debugging, the print function shows correct value for the variable containing the correct table name for $TableName. While looking at the archives, I figured out that it could be a bug with DBD::Oracle 1.13 & 1.14 and I need to patch my system. However, am not too sure about that, and want to confirm with the list before applying a patch. Incase, a patch has to be applied, could someone tell me how to go about identifying the version of DBD on solaris 8 box and where can I get the patch. Thanx, amit
