stored procedure without using Win32::OLE
I am trying to execute a stored procedure without using Win32::OLE.
When I use the following code, I get back "The object
'sp_Get_POSMvmtStats' does not exist in database 'ESS'"
use Win32::ADO;
use OLE;
$query_stmt = "sp_Get_POSMvmtStats $rtlr_nch_rqst_num, $actual_lines,
$actual_bytes, $rtlr_num";
$RS = $Conn->Execute($query_stmt);
if(!$RS) {
$errors = $Conn->Errors();
print "errors:\n";
foreach $error (keys %$errors) {
print $error->{Description}, "\n";
}
die;
}
Any ideas on what I am doing wrong. I am not using Win32::OLE because I
have not seen good examples that execute stored procedures.
