in reply to DBI use
Maybe I did not see not all errors. I could not run it.
#sub Got_Command ($$) { # don't use prototypes sub Got_Command { # my $Command = $1; # EXEC Command - defined earlier # my $Request_id = $2; my ($Command,$Request_id) = @_; # Pass parameters to a stored procedure print "$Command\n"; my $sthB_A = $dbh->prepare("$Command") or die "Couldn't prepare que +ry: ".$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_id +entifier = '".$Request_id."'\;"; my $get_results_B = $dbh->prepare("$Return_results") or die "Couldn +'t prepare query: ".$dbh->errstr; # $sth is conventional name for statement handle $get_results_B->execute() or die "Couldn't execute query: ".$get_res +ults_B->errstr; while (my @row = $get_results_B->fetchrow_array ) { foreach my $item (@row){ print OUTPUT_FILE "$item\n"; } } }
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: DBI use
by Win (Novice) on Nov 16, 2004 at 13:05 UTC | |
by erix (Prior) on Nov 16, 2004 at 13:16 UTC |