Alan,

Thanks for reply

Just trying with your suggestion but sp still not available :(


For my first rescue attention, i just see the internal of gbk files with dos
editor.
And i can "see" my SP code.

So far, i still making my SP again with info from my dos editor (the
parameter is not shown, but all of the sp code is still available )

For information,

- all data is ok
- all of triger doesn't available.

Here is the cronologies about this error

I have to SP

- SP_KALKULASI_BIAYA ( in english SP_CALCULATE_COST )
- SP_KALKULASI_1 ( SP_CALCULATE_1 )

The code in SP_Calculate_cost is to call SP_calculate_1

I open this 2 SP together...

Switch to SP_calculate_1 and add out parameter and compiled this SP ( with
EMS IB Manager tools ). Done...
Switch to SP_calculate_cost and add new parameter in the existing calls to
SP_calculate_1 ( adjust/add with new parameter )
and try to compile SP

Then errors occured with message invalid request BLR XXX

After that, i try to backup this db and still errors occured. (but gbk files
created)
And ( this is my fault ) restore to db production with this gbk ...

And the problem is occured.


End cronologies.

So far after rebuild all of my SP ( all of bussines rule is in sp ), i still
check all of db aspect ( sp code in gbk files is my first attention )

Maybe there is an chance to restore a gbk files and my SP is available again
without "hard" mode ?


regards
Bayu

> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Saturday, January 18, 2003 6:26 PM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Help me please. Restore db, but SP not
> available ( error invalid request BLR at offset 569. )
>
>
> can you try to restore with deactiating indexes set to true?
> Alan
>
> -----Original Message-----
> From: Bayu [mailto:bayu@...]
> Sent: Saturday, 18 January 2003 8:21 PM
> To: IB Support
> Subject: [ib-support] Help me please. Restore db, but SP not available (
> error invalid request BLR at offset 569. )
>
>
> Hi all,
>
> Please help me.
>
> I have a db which i restore from my backup files.
>
> My fault is i restore and overwrite the original db
>
> But there is error like
>
> Invalid token.
> invalid request BLR at offset 569.
> parameter mismatch for procedure SP_KALKULASI_1.
>
> And right now, i can't see all of my Stored Procedure.
>
> Please help me, how can't i restore or see my Stored Procedure again
> crying ... )
>
> My fault is i restore and overwrite the original db.
>
> Thanks and regards