Oracle stored procedure trouble

[Graeme Wilkinson]

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:

CallableStatement stmt = con.prepareCall("call ? := notification_pkg.process_xml_redeliver(?, ?, ?)");
stmt.registerOutParameter(1,OracleTypes.VARCHAR);
stmt.setLong(2, getNotificationId());
stmt.setLong(3, getChannelId());
stmt.setString(4, getDispatchXML());
ResultSet rs = stmt.executeQuery();

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]

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]

Graeme (or Joe?),
Actually it should be:

con.prepareCall("{? = call notification_pkg.process_xml_redeliver(?, ?, ?)}");

Good Luck,
Avi.