1. the ms sql stored procedure is posted in my comment. it does work.
2. there's no error at the prepare statement, the error is at Database error: Can't call method "bind_param" on an undefined value
3. ways tried:
$sql = q{ BEGIN
:rv := sp_updateStorageSystem(parameter1_in => ?,
parameter2_in => ?
);
END;
};
a) $sth = $dbh->prepare( $sql ) or die $dbh->errstr;
b) $sth = $dbh->prepare( "exec sp_updateStorageSystem" ) or die $dbh->errstr;
c) $sth = $dbh->prepare( "begin sp_updateStorageSystem end;" ) or die $dbh->errstr;
4. using dbd::odbc
how does bind_param works?