File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Java Interview Guide this week in the Jobs Discussion 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
jQuery in Action, 3rd edition