usp_deleterole.sql

数据库学习的绝好例子简单的数据库经典入门

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;