> sorry i've put it wrong - 100 - 150 INSERTSs are inserts into other
> tables, not CREATE PROCEDURE sql.

so the SP(s) comprises 100-150 static INSERT statements?
Alan

>
> --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
> wrote:
> > >
> > > 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
>
>
>
>
>
>
>