Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Calling procedure - error" Watch "Calling procedure - error" New topic

Calling procedure - error

Suhas Mohamedali

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

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.
I agree. Here's the link:
subject: Calling procedure - error
It's not a secret anymore!