create or replace procedure sp_affair_insert
(
p_affairid in varchar2,
p_affairstate in varchar2,
p_affairtypeid in varchar2
)
as
begin
insert into affair(affairid,affairstate,affairtypeid)
values(p_affairid,p_affairstate,p_affairtypeid);
end;

<hibernate-mapping package="org.Debug.Hibernate.yhb">

<class name="Affair" table="AFFAIR">
<id name="affairid" column="AFFAIRID" type="string">
<generator class="assigned"/>
</id>

<property name="affairstate" column="AFFAIRSTATE" type="string" not-null="true" />
<property name="affairtypeid" column="AFFAIRTYPEID" type="string" not-null="true" />

<sql-insert callable="true">{call sp_affair_insert(?,?,?)}</sql-insert>
</class>

</hibernate-mapping>