usp_approvetimesheet.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 18 行

CREATE OR REPLACE PROCEDURE usp_ApproveTimeSheet
(
   inTimeSheetID   CHAR,
   inManagerID     CHAR
)
AS

BEGIN
   UPDATE TimeSheets
      SET ApprovalDate = SYSDATE,
      ManagerID = inManagerID
      WHERE TimeSheetID = inTimeSheetID;
   EXCEPTION
      WHEN OTHERS THEN
      RAISE_APPLICATION_ERROR( -20999,'Approve timesheet failed.');
      RETURN;
END;