i have this old kind of problem that i saw many times on the forum, but rereading them did not give me the answer i'm looking for.
The short story:
I have an SP (B) that uses another SP (A). I have added a new input parameter to SP A (a month ago). And looks like i did not recompile SP B. That was my mistake #1.
Unfortunately i did a mistake #2: i restored the database from the morning backup (with overwrite option of course
And at restore i got the following:
# fbrst /tmp/p.fbk test -REP
gbak: ERROR:invalid request BLR at offset 297
gbak: ERROR: Input parameter mismatch for procedure SYS$MENU_FULL
gbak:Exiting before completion due to errors
The domains, tables (with data), generators, exceptions, UDFs, roles, indices are all back...but my triggers and SPs are all missing now.
I tried GBAK -M and GBAK -N but didn't help.
I need to restore my SPs without validating them, then i'll correct that parameter issue and backup it correctly.
I know there i can find all my SP contents in text format in the fbk file....but i will commit suicide if i have to restore my 1200 SP+triggers that copy+paste way.
Please save my life and help me! There must be an easy way to correct this.