CREATE PROC SP_DAVE
AS
BEGIN
    update mytable set st = getdate() 
    where  date = getdate();
    if @@rowcount != 1
    begin
        RAISERROR ('No Rows !!',16,1);
        RETURN -1;
    end
    RETURN 0;
END;

##</code><code>##

	$sql = "EXEC SP_DAVE"; 
	$sth = $dbh->prepare($sql);
        $sth->execute 
           or 
              print "\nError EXECUTE\n$DBI::errstr\n";