Hibernate what class need to be specified when calling stored procedure which only returns a number

[heng zhang]

Hi all
i have a named query declared as follows

<sql-query name="GetCurrentSubjectId_SP" callable="true">
        {? = call GetCurrentSubjectId() }
   </sql-query>

it is a stored procedure which needs no parameters and returns only a number.

so what return class i need to specify here?

[heng zhang]

here is how I execute the named query:

Query query=session.getNamedQuery("GetCurrentSubjectId_SP");
			long id=(Long)query.uniqueResult();

[heng zhang]

and I get the errors of java.sql.SQLException: ORA-06550 expression is of wrong type


i think i need to specify a return type.


sorry i cannot post the full errors here, because it's said i have abbreviations in my posting even if i use code tag