java - 出现错误 --- 无法对 PLSQL 语句执行 fetch : next

Question

我编写了一个存储过程，用于在 Spring 中使用 hibernate 插入 Oracle 的表中。当我从 hibernate 调用该过程时，插入了数据，但出现以下错误

Cannot perform fetch on a PLSQL statement: next

程序

create or replace PROCEDURE INSERT_ITEM_TYPE(
   ITEM_TYPE_ID IN number ,
   TYPE_NAME         IN VARCHAR2 ,
    BN_NAME      IN VARCHAR2 ,
    CREATED_BY   IN NUMBER ,
    CREATED_ON   IN DATE ,
    UPDATED_BY   IN NUMBER ,
    UPDATED_ON   IN DATE ,
    IS_DELETED   IN NUMBER  )
AS
BEGIN
  INSERT
  INTO pg_item_type 
    (
      ITEM_TYPE_ID,
      ITEM_TYPE_NAME,
      BN_ITEM_TYPE_NAME,
      CREATED_BY,
      CREATED_ON,
      UPDATED_BY,
      UPDATED_ON,
      IS_DELETED
    )
    VALUES 

    (
    ITEM_TYPE_ID,
    TYPE_NAME,
    BN_NAME,
    CREATED_BY,
    CREATED_ON,
    UPDATED_BY,
    UPDATED_ON,
    IS_DELETED
    );


    commit;
END INSERT_ITEM_TYPE;

模型类

@Entity
@Table(name = "PG_ITEM_TYPE")
@NamedNativeQueries({
    @NamedNativeQuery(
    name = "insertyItemType",
    query = "CALL     INSERT_ITEM_TYPE(:id,:name,:bnName,:cretedBy,:createdOn,:updatedBy,:updatedOn,:isDeletd)",
    resultClass = GdItemType.class
    )
})

public class GdItemType {
.....
}

** DAO **

    @Override
        public void saveGdItemType(GdItemType gdItemType) {
            Session session = this.sessionFactory.getCurrentSession();
            //session.saveOrUpdate(gdItemType);
            Query query =  session.getNamedQuery("insertyItemType")
                    .setParameter("id", gdItemType.getItemTypeId())
                    .setParameter("name", gdItemType.getItemTypeName())
                    .setParameter("bnName", gdItemType.getBnItemTypeName())
                    .setParameter("cretedBy", gdItemType.getCreatedBy())
                    .setParameter("createdOn", gdItemType.getCreatedOn())
                    .setParameter("updatedBy", gdItemType.getUpdatedBy())
                    .setParameter("updatedOn", gdItemType.getUpdatedOn() )
                    .setParameter("isDeletd", gdItemType.getIsDeleted());
                    query.list();


        }

我被困在这里了。有人可以帮帮我吗......

Answer 1

query.list() 

想要以列表形式返回查询结果。您的过程没有任何“out”参数，因此查询不会返回要放入列表中的结果。因此出现错误。