usp_submittimesheet.sql

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

CREATE OR REPLACE PROCEDURE usp_SubmitTimeSheet
(
   inTimeSheetID   CHAR
)
AS

BEGIN
   UPDATE TimeSheets
      SET Submitted = 1
      WHERE TimeSheetID = inTimeSheetID;
   EXCEPTION
      WHEN OTHERS THEN
      RAISE_APPLICATION_ERROR( -20999,'Submit timesheet failed.');
      RETURN;
END;