Subject | Re: [Firebird-Java] CallableStatement.getParameterMetaData() fails |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-03-04T19:57:12Z |
> I have debugged this following procedure call using this procedure:You have forgotten CallableStatement.registerOutParam(int, int) call as I
>
> CREATE PROCEDURE ADD_NUMBERS (NUM1 INTEGER, NUM2 INTEGER) RETURNS (RES
> INTEGER)
> AS BEGIN
> RES = NUM1 + NUM2;
> END
>
> And this CallableStatement:
> {CALL ADD_NUMBERS(?, ?, ?)}
suggested in my private email.
> When debugging, I can tell thatUnless you mark some params as out all they are treated as in.
> {CALL ADD_NUMBERS(?, ?, ?)}
> gets converted to
> EXECUTE PROCEDURE ADD_NUMBERS(?, ?, ?)
>
> I'm guessing the conversion to native procedure call is the problem?
Roman