Question

I m 绘制甲骨质11g储存程序图,作为NHibernate s.hbm.xml绘图档案的指挥系统。

  <class name="Person" table="PERSONS">
    <id name="Id" column="COD_PERSON" />
    <property name="Name" column="NAME" />

    <property name="AuditField1" column="AUDITFIELD1" />
    <property name="AuditField2" column="AUDITFIELD2" />
    <property name="AuditField3" column="AUDITFIELD3" />

    <sql-insert>exec PKG_PERSONS.insert_sp ?,?</sql-insert>
  </class>

This is the stored procedure:

create or replace package body PKG_PERSONS is
  procedure insert_sp(pcod_person  persons.cod_person%type, 
                      pname        persons.name%type) is
  begin
    insert into persons(cod_person, name) values(pcod_person, pname);
  end;

从这一绘图中,Im期望Id和名称特性会作为参数发送,但肯定会发生这种情况;我把这一错误从Oracle带走:ORA-01036:非法变量名称/编号。 NHibernate显示了康索尔窗口的一些标志,似乎同NH一样试图绘制包括审计领域在内的所有财产图,以采用所储存的程序。

Maybe is this the source s error?

这一预期行为吗?

能否具体确定哪些财产作为NH3/ Oracle的参数?

提前感谢。

Answer 1

经确认,国家卫生局试图作为参数发送每个实体,其财产分布图如下:<代码><sql-insert>/<sql-update>储存程序,但你可以例外插入/更新日期=false。

另一个问题是执行Oracle11g储存程序的右轴,这是与NH3.3和Oracle一起为我工作的地图。数据:4.112.2.0:

  <class name="Person" table="PERSONS">
    <id name="Id" column="COD_PERSON" />
    <property name="Name" column="NAME" />

    <property name="AuditField1" column="AUDITFIELD1" insert="false" update="false" />
    <property name="AuditField2" column="AUDITFIELD2" insert="false" update="false" />
    <property name="AuditField3" column="AUDITFIELD3" insert="false" update="false" />

    <sql-insert check="none">begin PKG_PERSONS.insert_sp(:p0,:p1); end;</sql-insert>
  </class>

I had to redefine the parameter s order, because Id property is send at last position:

create or replace package body PKG_PERSONS is
  procedure insert_sp(pname        persons.name%type,
                      pcod_person  persons.cod_person%type
                      ) is
  begin
    insert into persons(cod_person, name) values(pcod_person, pname);
  end;

Maybe this will help somebody else, Thanks.

友情链接