usp_deleteuser.sql

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

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;