Content of the Custom Stored Procedure sp_I_Uom_Log

CREATE PROCEDURE sp_I_Uom_Log

(@description nvarchar(40)

,@abbreviation nvarchar(20)

,@last_edit_comment nvarchar(254) = NULL

,@my_arg nvarchar(40) = null

,@last_edit_at datetime OUT

,@uom_id int OUT

) AS

BEGIN

SET NOCOUNT ON

DECLARE @logged_at DATETIME

--Call other SPs if needed.

SET @logged_at = GETDATE()

INSERT INTO error_log (logged_at, severity, instance_info

, object_name, object_section, description, system_msg)

VALUES (@logged_at, 0, @abbreviation

, @description, @description, @description, @description)

SET @uom_id = SCOPE_IDENTITY()

--Call other SPs if needed.

raiserror('Error message from the custom hook stored procedure - sp_I_Uom_Log', 16, 1)

END

GO