I think, he wanted to write, that 100-150 INSERTs made up the SP, and not the INSERTs create the SP.

----- Original Message -----
From: Alan McDonald
To: firebird-support@yahoogroups.com
Sent: Wednesday, October 05, 2005 11:51 AM
Subject: RE: [firebird-support] Re: cant create new stored proc


>
> I am using IB Expert to manage my DB objects.
>
> I just did backup and restore but it doesnt help...Still the same
> error.
>
> The procedure code is just a big number of INSERTs...maybe 10o or
> 150...nothing else...No difficult queries...This is the only SQL
> uncommited at the moment...(i.e. the SQL which creates SP)...
>

huh? INSERT statements which create SPs? 100-150 INSERT statements which
create SPs....
show us please
Alan

> Any more ideas?
>
> --- In firebird-support@yahoogroups.com, "d_dude_2003"
> <d_dude_2003@y...> 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...
> >
> > Any ideas?
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links








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