JAVA自动捕获plsql异常_java - java.sql.SQLException：无法对PLSQL语句执行获取：next - 堆栈内存溢出...

我正在尝试使用hibernate在oracle中执行存储过程。当我从hibernate调用过程时，该过程被调用，但之后它向我显示异常

ERROR: Cannot perform fetch on a PLSQL statement: next

这是我在oracle中的存储过程：

create or replace PROCEDURE GETREGISTRATIONRECORDS

(

REGID IN NUMBER

)

AS

MY_CURSER SYS_REFCURSOR;

BEGIN

OPEN MY_CURSER FOR

SELECT * FROM REGISTRATION

WHERE ID = REGID;

END GETREGISTRATIONRECORDS;

在休眠状态下，我已按如下所示调用了此过程：

注册.java

@NamedNativeQueries({

@NamedNativeQuery(

name="callRegistrationProcedure",

query="call GETREGISTRATIONRECORDS(:regID)",

resultClass=Registration.class)

})

@Entity

public class Registration {

......

}

在RegistrationDao.java中，我具有以下功能

@SuppressWarnings("unchecked")

public List getFirstName(int id)

{

Query query = SQLFactory.getSession().getNamedQuery("callRegistrationProcedure").setParameter("regID", id);

List result = query.list();

for(int i=0; i

Registration stock = (Registration)result.get(i);

System.out.println(stock.getFirstName());

System.out.println(stock.getLastName());

}

return result;

}

但是，当我执行我的应用程序时，出现以下错误：

Hibernate: call GETREGISTRATIONRECORDS(?)

Apr 09, 2015 10:45:24 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

WARN: SQL Error: 17166, SQLState: null

Apr 09, 2015 10:45:24 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

ERROR: Cannot perform fetch on a PLSQL statement: next

Apr 09, 2015 10:45:24 AM org.apache.catalina.core.StandardWrapperValve invoke

SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/SpringHibernateWebApplication] threw exception [Request processing failed; nested exception is org.hibernate.exception.GenericJDBCException: Cannot perform fetch on a PLSQL statement: next] with root cause

java.sql.SQLException: Cannot perform fetch on a PLSQL statement: next

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:192)

我已经通过这些链接，但是没有找到解决方案

因此，请帮助我获得解决方案。