Hi Guys,
The following $sql querry is being executed in the toad well and getting
output as C.
While trying to fetch the value through DBI ,it outputs the value as I.
Please suggest me to get the right one..Thanks.
#Code starts here
my $sql = qq[*SELECT MAX(last_run_status)
KEEP (DENSE_RANK LAST ORDER BY last_run_datetime) FROM
interface_control_table
WHERE job_id = 'INT_002' *];
my $sth = $dbh->prepare($sql);
$sth->execute();
my $matches= $sth->rows();
print "$matches\n"; # prints 0
while (my @row = $sth->fetchrow_array) {
print"@row\n";# *prints I instead of C.*
}
#Code ends here
