wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes Calling procedure - error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Calling procedure - error" Watch "Calling procedure - error" New topic
Author

Calling procedure - error

Suhas Mohamedali
Greenhorn

Joined: Jun 05, 2012
Posts: 29
Please help to call a stored procedure

get_ubpi(p_policy_short_no in varchar2, p_category_code in varchar2) with 2 in params and no out param.

The code i used to call the proc is



which gave me

15:00:58,989 WARN [JDBCExceptionReporter] SQL Error: 900, SQLState: 42000
15:00:58,989 ERROR [JDBCExceptionReporter] ORA-00900: invalid SQL statement

Please help
Dean Witcraft
Greenhorn

Joined: Feb 19, 2013
Posts: 1
I think you're using javax.persistence.Query and need to be using org.hibernate.Query. see if this has an answer for you.
https://forum.hibernate.org/viewtopic.php?f=1&t=1025473&p=2467857#p2467857
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Calling procedure - error