Subject Re: [firebird-support] cant create new stored proc
Author Ann W. Harrison
d_dude_2003 wrote:
> running on FB 1.5 i already have about 10 SPs in db
> and i need to create one more.
>
> here is the error message:
>
> Invalid token.
> Invalid request BLR at offset XXXXX.
> Too many contexts of relation/procedure/views. Maximum allowed is
> 127...

The problem is not with the number of procedures or the number of times
you've modified things. Your procedure has a query that involves more
than 127 input streams - look for a multi-way join of complex views.

Regards,


Ann