Subject IB_StoredProc design time syntax problem (bug?) 4.2fm
Author mmenaz
I've a procedure like this:
CREATE PROCEDURE INT64_TO_COMPACT_CODE (
IN_INTERO NUMERIC (18, 0),
IN_BASE INTEGER)
RETURNS (
OUT_0Z VARCHAR (30))
AS
...

At design time in the IB_StoredProc SQL I write:

EXECUTE PROCEDURE INT64_TO_COMPACT_CODE(?ID, 36)

This way prepare works, I can assign a parameter, everything is ok.

When I press OK or Apply and then reopen the design editor the SQL has changed to:

EXECUTE PROCEDURE INT64_TO_COMPACT_CODE
?ID

This way, the prepare gives an error:
ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
parameter mismatch for procedure INT64_TO_COMPACT_CODE

STATEMENT:
TIB_Cursor: "<TApplication>.frmSQL.crEdit."

And the SQL part of the error window is:
EXECUTE PROCEDURE INT64_TO_COMPACT_CODE
? /* ID */

What have I done wrong?
Thanks
Marco Menardi