Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling procedure - error

 
Suhas Mohamedali
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic