aspose file tools*
The moose likes Object Relational Mapping and the fly likes Hibernate what class need to be specified when calling stored procedure which only returns a number Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate what class need to be specified when calling stored procedure which only returns a number " Watch "Hibernate what class need to be specified when calling stored procedure which only returns a number " New topic
Author

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

heng zhang
Greenhorn

Joined: Jul 12, 2010
Posts: 16
Hi all
i have a named query declared as follows




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
Greenhorn

Joined: Jul 12, 2010
Posts: 16
here is how I execute the named query:

heng zhang
Greenhorn

Joined: Jul 12, 2010
Posts: 16
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate what class need to be specified when calling stored procedure which only returns a number