Subject | IB_StoredProc design time syntax problem (bug?) 4.2fm |
---|---|
Author | mmenaz |
Post date | 2001-12-05T18:17:44Z |
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
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