Hi
I am executing a stored procedure..I am getting these errors..help is appreciated..ANd i am sure I will assign full credit who helps me..Plz do help me..

Stored Procedure:

CREATE OR REPLACE FUNCTION BOOK2

RETURN SYS_REFCURSOR
AS
st_cursor SYS_REFCURSOR;


BEGIN

OPEN st_cursor FOR
SELECT BOOK_NAME FROM BOOK;

RETURN st_cursor;


END Book2;
/



<sql-query name="myQuery" callable="true">
<return alias="emp" class="Tut.First.Book">
<return-property name="bookname" column="BOOK_NAME" />

</return>
{ ? = call BOOK2() }
</sql-query>




Code 2:
Query sel = session.getNamedQuery("myQuery");
List list = sel.list();

Quote:

Errors...

Hibernate: { ? = call BOOK2() }
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2150)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
at org.hibernate.loader.Loader.list(Loader.java:2021)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:109)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1575)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:165)
at Tut.First.Client.main(Client.java:26)
Caused by: java.sql.SQLException: Invalid column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5971)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1527)
at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1540)
at org.hibernate.type.LongType.get(LongType.java:28)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1088)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:553)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
at org.hibernate.loader.Loader.doList(Loader.java:2147)
... 6 more
could not execute query

It is failing trying to find a long (numeric) column in your SQL result. I believe you want to make sure you're at least also mapping the class's <id> property in the <return-property> elements. So that means you'll need to modify the SP to return the primary key as well.

Let me know how can i give you full point.. i am willing to give u full points but i am not fidning anything to give..suggest the way to give u full points.. i am new here..
Thanks