I probably should include DBI and DBD::ADO versions too: I'm using DBI 1.15
and DBD::ADO 0.4 revision 1.19. My syntax for calling stored procs is
exactly what's stated in Programming the Perl DBI:
my $sth = $dbh->do("{call ClsAct_getSA('01F')}");
except, of course, that the docs say that passing params to SPs isn't
supported. I'd be grateful for any suggestions as I'm quite desperate and
frustrated at the moment :-)
David
> Hi all,
>
> This seems like a very basic question that should have been asked/answered
> before, but I can find no reference to it in the dbi-users archives. My
> apologies if I'm ignorant of a previously-posted solution.
>
> That said, I'm trying to figure out how to pass parameters to stored procs
> with DBD::ADO. Both 'Programming the Perl DBI' and recent (I think) DBD::ADO
> docs say that limited support for stored procs is provided and that passing
> params isn't possible. But it seems that there must be a way to do this
> using DBD::ADO without switching to DBD::ODBC or some other DBD.
>
> Any suggestions?
>
> TIA,
> David Iberri
