Re: Calling SQLServer Stored Procedures

[Roger Perttu]

Brien Pirkle wrote:

Jeff,

So, assuming sp_foo takes no paramters, my whole script could be:

#####################
use DBI;
       my $dbh = DBI->connect('DBI:ODBC:OSTDB', 'user', 'password')
               or die "Couldn't connect to database: " . DBI->errstr;

{call sp_foo}

#More like this:
my $sth = $dbh->prepare('{call sp_foo}');
$sth->execute();
# or check up on do in the dbi docs

#####################