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
    Does the file handle have to be within the subroutine?

      If you want to write your database data somewhere else, take it there.

      You can gather the @rows and return the data. Or you can pass a filename/filehandle into the subroutine, which is probably better.

      But you must really get your questions more precise, and give error messages. Not everybody has as much time as I take.

      update: see also:
      DBI recipes
      Speeding up the DBI