usp_deleteuser.sql

来自「数据库学习的绝好例子简单的数据库经典入门」· SQL 代码 · 共 15 行

CREATE OR REPLACE PROCEDURE usp_DeleteUser
(
   inUserID   CHAR
)
AS

BEGIN
   DELETE FROM Users
   WHERE UserID = inUserID;
   EXCEPTION
      WHEN OTHERS THEN
      RAISE_APPLICATION_ERROR( -20999,'Delete user failed.');
      RETURN;
END;