usp_deleterole.sql

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

CREATE OR REPLACE PROCEDURE usp_DeleteRole
(
   inRoleID   CHAR
)
AS

BEGIN
   DELETE FROM Roles
   WHERE RoleID = inRoleID;
   EXCEPTION
      WHEN OTHERS THEN
      RAISE_APPLICATION_ERROR( -20999,'Delete role failed.');
      RETURN;
END;