Re: weird error in my JDBC code

[Guy Harrison]

This works for me (Connector/J version 3.1.10):

static public void outparameter(Connection MyConnect) throws SQLException {

CallableStatement PreparedProc = MyConnect
.prepareCall("{CALL hello(?)}");
PreparedProc.registerOutParameter(1, Types.CHAR);
boolean hasResults = PreparedProc.execute();
String what = PreparedProc.getString(1);
System.out.println(what);
}

The stored procedure definition looks like this:

CREATE PROCEDURE hello(OUT outparm VARCHAR(20)) NO SQL
BEGIN
SET outparm='World';
END$$