I just tried it and I get:
Bad hash at /usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 940, <INP>
line 14.
Sherry
Phillip Perkins wrote:
> 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
