• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle stored procedure trouble

 
Graeme Wilkinson
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am trying to call an oracle stored procedure but i get an error
java.sql.SQLException: ORA-01745: invalid host/bind variable name
when I try the executeQuery().

My code is as follows:


I unfortunately did not write the procedure or have access to it right now.

Any suggestions on a fix, or even a better description of the error?

Thanks,
Joe
 
Graeme Wilkinson
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Feeling really stupid about this but the error is in the prepare call :
con.prepareCall("call ? := notification_pkg.process_xml_redeliver(?, ?, ?)");

should be

con.prepareCall("{ call ? := notification_pkg.process_xml_redeliver(?, ?, ?) }");
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Graeme (or Joe?),
Actually it should be:

Good Luck,
Avi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic