Subject Re: [firebird-support] Some feed back on a possible gotcha
Author Martijn Tonies
Hello Grant,

> Recently we posted a question relating to an error message the we
> received during a restore of a FB 1.5 DB
> >gbak: restoring index FK_CLIENT_REP_LETTERS
> >gbak: restoring index FK_COMPANY_LETERS
> >ERROR: invalid request BLR at offset 917
> >parameter mismatch for procedure AUTOTEXT_TOWN_DATA
> The real culprit turned out to be incorrect parameters being passed by a
> SP that was calling the AUTOTEXT_TOWN_DATA stored procedure. 3
> parameters were supposed to be passed when infact only a single
> parameter was being passed.
> As it turned out the calling SP was an old SP that was no longer in use
> so the issue only showed up during a restore or a complete re-compile of
> all stored procedures.
> The AUTOTEXT_TOWN_DATA stored procedure had in fact been changed after
> the calling SP had been compiled and hence why the AUTOTEXT_TOWN_DATA
> stored procedure compiled OK on an individual basis.
> No theres a gotcha.

It sure is...

I thought that this wasn't possible - that is, to add parameters without an
message :-)

Seems Firebird is a bit off in this area.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!