Hi All,
Does anyone have experience with using Perl, DBI, ADO to execute SQL Stored
procedure that can update input parameters for use as output.
Here is my example: sp_test_1 is stored proc that chancges value of $y. Perl
script:
use DBI;
use DBD::ADO;
$dbh = DBI->connect('dbi:ADO:DSN', 'name', 'password')
|| die $DBI::errstr;
$y = 5;
$sth = $dbh->prepare("execute sp_test_1 ?");
$rc = $sth->bind_param_inout(1, \$y, 1) || die $dbh->errstr;
$sth->execute;
$dbh->disconnect;
print "y = $y\n";
It must be 10 after call.
sp_test_1 works from Query Analyzer, but when I run this script I get a
stange error:
"Can't locate DBI object method "bind_param_inout" via package
"DBD::ADO::st"."
As far as I know there is no st package. Can you explain why it doesn't
work?
Thank you.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
