usp_updatetimesheetitem.sql

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

CREATE OR REPLACE PROCEDURE usp_UpdateTimeSheetItem
(
   inTimeSheetItemID   CHAR,
   inHours             NUMBER
)
AS
BEGIN
   UPDATE TimeSheetItems
      SET Hours = inHours
      WHERE TimeSheetItemID = inTimeSheetItemID;
   EXCEPTION
      WHEN OTHERS THEN
      RAISE_APPLICATION_ERROR( -20999,'Update timesheet item failed.');
      RETURN;
END;