sub Got_Command ($$) { my $Command = $1; # EXEC Command - defined earlier my $Request_id = $2; # Pass parameters to a stored procedure print "$Command\n"; my $sthB_A = $dbh->prepare("$Command") or die "Couldn't prepare query: ".$dbh->errstr; $sthB_A->execute() or die "Couldn't execute query: ".$sthB_A->errstr; ########################################## # Return Results here # ########################################## $Return_results = "Select * from Result_storage_keep where Unique_identifier = '".$Request_id."'\;"; my $get_results_B = $dbh->prepare("$Return_results") or die "Couldn't prepare query: ".$dbh->errstr; $get_results_B->execute() or die "Couldn't execute query: ".$get_results_B->errstr; while (my @row = $get_results_B->fetchrow_array ) { } foreach (@row){ print OUTPUT_FILE "$item0\n"; } }