hi:
i write a procedure of oracle:
/**********************************************/
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;
and in the hbm.xml i write:
/*************************************************/
<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>[/code]
i find the order of parameter become out-of-order,not the order i hope

i can't find the rule of the procedure parameter order from the document of the hibernate3!
can some one tell the rule of parameter order (only id to the last parameter,i mark the parameter order in specifical color)!

thanks for any help!

You currently have to match whatever order Hibernate would use for its insert statement. Here is an excerpt from the docs (http://www.hibernate.org/hib_docs/v3/reference/en/html/querysql.html#querysql-cud):

A regular parameter for hibernate's procedure is so easy for author,why did you like the out-of-order parameter ?

before i want to write a automatic code for oracle procedure by my java code ,but the order of parameter is not regular ,so i can't realize some thing?

thanks for any help!