Subject RE: [ib-support] Re: Help me please. Restore db, but SP not available ( error invalid request BLR at offset 569. )
Author Sivaraman Krishnan
Hello,
Once i had the same problem.The problem is , i added one new input
parameter and alter the existing the procedure.
But the problem happened at the time of altering.Once i tried to restore
only i could find this problem.I am using ibexpert tool.
So whenever we add the new input parameter, better to drop the existing
procedure and recreate the new procedure.
Once i dropped the existing procedure and recreated the new procedure, i
couldn't find this problem.

Sivaraman
Software Associates Information Technology,
Calicut,
India.


At 10:01 AM 20/01/2003 +0700, you wrote:
>Hi all,
>
>Thanks for all of your response.
>
>Right now, i have complete recovery all of my sp, which i can get from gbk
>files ( look gbk internal files ) and then copy paste and rebuild this sp
>again
>
> > and don't worry to much, I think that the data is already restored,
> > you only need to add the missing stored procedures
> >
> > <c_pradelli@y...> wrote:
> > > Try to restore using latest FB1.5. It contain some improvement for
> > this
> > > issue
>
>
>I will try with this sugesstion
>
>regards
>Bayu
>
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://rd.yahoo.com/M=241773.2861422.4212389.1925585/D=egroupweb/S=1705115386:HM/A=1394045/R=0/*http://www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_5802,FF.html>21b2cf.jpg
>
>21b3b9.jpg
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.


[Non-text portions of this message have been removed]