Subject prepareCall problem
Author info@wilsoncom.de
Hi,
I´m trying to call a stored procedure GET_NOTIZID which has no input parame=
ters and one output parameter of type INTEGER:

CREATE PROCEDURE GET_NOTIZID returns (ID Integer)
AS
BEGIN
ID = gen_id(NOTIZ_GEN, 0);
SUSPEND;
END

It works fine in isql, but when i try calling it in a java-app. using:
CallableStatement cstmt = oSQLConn.prepareCall( "{call GET_NOTIZID(?)}" );
cstmt.registerOutParameter( 1, Types.INTEGER );
ResultSet rs = cstmt.executeQuery();
rs.next();
ret = rs.getInt( 1 );

I get the following error-message:

[interclient][interbase] Dynamic SQL Error
parameter mismatch for procedure GET_NOTIZID

interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL Er=
ror
parameter mismatch for procedure GET_NOTIZID

Anybody got any an idea what i´m doing wrong?
TIA.
Mark