Have you tried $records_affected = $dbh->do($statement); ?
Sherry Graham wrote:
> I am a newbie to DBI programming with ASA. I can connect to my database
> and make simple SQL queries just fine, but I am unable to call a stored
> procedure. Is there something special that needs to be done?
>
> The error I get is Bad hash at ./program.pl line 427
>
> My stored procedure statements are:
>
> my $statement = "call add_person (sql_first_name =
> 'sherry',sql_last_name = 'graham', sql_status = 'n', sql_person_id =
> 1)";
> my $sth = $dbh->prepare($statement);
> $sth->execute;
> $sth->finish;
>
> Any suggestions?
>
> Thanks!
> Sherry Graham
> [EMAIL PROTECTED]
> Applied Systems Intelligence
