I am having an issue with delete when I use the below code to delete the data from the table.
my $dbh=DBI->connect("dbi:Oracle:host=fit.fmr.com;port=1521;service_name=user1","passwd1", "userdev");
my $rows = $dbh->do("DELETE from cnv_batches where PROJECT_CD='METLIFE'");
print "Number of rows deleted: $rows";
when I run the above script I get the below error. No rows are deleted.
Number of rows deleted: 0E0