Subject | prepareCall problem |
---|---|
Author | info@wilsoncom.de |
Post date | 2001-10-18T08:46:29Z |
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
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