Subject Re: cant create new stored proc
Author d_dude_2003
sorry i've put it wrong - 100 - 150 INSERTSs are inserts into other
tables, not CREATE PROCEDURE sql.

--- 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
> >
> >
> >
> >
> >
> >
> >