Hi chandran,
I have a Oracle stored procedure with the following prototype:
procedure get_message(msg out varchar2)
In my Java program after successfull connection to my Personal Oracle7 I do:
...
try {
CallableStatement cs = con.prepareCall("{call message(?)}");
cs.registerOutParameter(1, Types.VARCHAR);
cs.executeUpdate();
String msg = cs.getString(1);
} catch (Exception ex) {
System.out.println(ex.getMessage());
}
...
What am I doing wrong?
Thanks
Ambrose