File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling procedure - error
 
Similar Threads
Sotre procedure not calling from Linux
Error while inserting data through procedure
Error :java.sql.SQLException: Invalid column index
ORA-01858: a non-numeric character was found where a numeric was expected
wrong number or types of arguments in call to 'P_RETRIEVE_OPPTY_ORDER_STATUS'