ALTER proc [dbo].[InsertAdmRolesList]
    @NAME varchar(60),
    @DATE_BEGIN datetime,
    @DATE_END datetime,
    @DESCRIPTION varchar(255),
    @UPDATE_DATE datetime,
    @ROLE_ID uniqueidentifier output
AS
SET @ROLE_ID = newid()
INSERT INTO ADMIN.ADM_ROLES_LIST
(
    [ROLE_ID],
    [NAME],
    [DATE_BEGIN],
    [DATE_END],
    [DESCRIPTION],
    [UPDATE_DATE]
)
VALUES
(
	@ROLE_ID,
    @NAME,
    @DATE_BEGIN,
    @DATE_END,
    @DESCRIPTION,
    @UPDATE_DATE
)

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
    namespace="StatesIF.Mappings" assembly="StatesIF">
    <class name="RolesList" table="ADMIN.ADM_ROLES_LIST">
        <id name="RoleId">
            <column name="ROLE_ID" sql-type="Guid" not-null="true"/>
            <generator class="identity"/>
        </id>
        <property name="Name">
            <column name="NAME" not-null="true"/>
        </property>
        <property name="DateBegin">
            <column name="DATE_BEGIN" not-null="true"/>
        </property>
        <property name="DateEnd">
            <column name="DATE_END"/>
        </property>
        <property name="Description">
            <column name="DESCRIPTION"/>
        </property>
        <property name="UpdateDate">
            <column name="UPDATE_DATE"/>
        </property>
      <sql-insert>
        exec InsertAdmRolesList
        @NAME = ?,
        @DATE_BEGIN = ?,
        @DATE_END = ?,
        @DESCRIPTION = ?,
        @UPDATE_DATE = ?,
        @ROLE_ID = ? out
      </sql-insert>
    </class>
</hibernate-mapping>

Необходимо объявить скалярную переменную "@p5".
could not insert: [StatesIF.Mappings.RolesList][SQL: exec InsertAdmRolesList
        @NAME = ?,
        @DATE_BEGIN = ?,
        @DATE_END = ?,
        @DESCRIPTION = ?,
        @UPDATE_DATE = ?,
        @ROLE_ID = ? out]