Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to call function from hibernate??  RSS feed

 
Vimal Panchal
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Javaties,

I new with hibernate can you please help to call oracle function from hibernate?
I am getting some error in that.
See the code which i have return in main file.
and call the function many way but didn't get any result.




[Edited to use code tags - Paul Sturrock]
[ June 22, 2007: Message edited by: Paul Sturrock ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I am getting some error in that.

What does the error say?
 
Mark Spritzler
ranger
Sheriff
Posts: 17309
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You cannot call a Stored Procedure/Function that way, your named query is no where to be found, that is the error that you are getting.

Here is the Hibernate docs for using Stored Procedures/Functions

http://www.hibernate.org/hib_docs/v3/reference/en/html/querysql.html#sp_query

Good Luck

Mark
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!