This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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.
Don't get me started about those stupid light bulbs.
subject: Calling procedure - error
Similar Threads
Sotre procedure not calling from Linux
Error :java.sql.SQLException: Invalid column index
wrong number or types of arguments in call to 'P_RETRIEVE_OPPTY_ORDER_STATUS'
ORA-01858: a non-numeric character was found where a numeric was expected
Error while inserting data through procedure